MySQL permission problem

I get this error : ERROR 1006: Can't create database 'databasename'. (errno

[Lmax]

When i try to create a database in mysql i get this error

ERROR 1006: Can't create database 'databasename'. (errno: 13)

I found out what the error means. It means i have no permissions. But i'm logged in as root. How is it possible i have no permissions anymore, and how can i reset them so i can add databases again.

Does anybody know how this is caused and how i can solve it.

Thanks

A. Lantink

(edited by: littleman at 5:01 am (gmt) on Sep. 3, 2001

[littleman]

The password system for MySQL is independent of the password system fir the *nix system.
Wdv.com [wdvl.com] has a good tutorial on basic MySQL functions including setting permissions for databases.

[Lmax]

The problem is that i'm logged in as root. I don't have any permissions anymore as root. How can i reset these.

[jatar_k]

I think your best bet is mysql.com they know everything. I had the same problems once when we dropped the permissions table, I think we ended up resetting the default prefs but I can't remember if we reinstalled. I do remember we found the answer at the mysql site though.

<added>
by the way welcome to webmasterworld Lmax

[Lmax]

Thanks for the welcome.

And i cheched mysql.com. But the mention nothing about root permissions. or resetting them. They only talk about resetting the root password, but that isn't the problem.

[Air]

There is a table in the database "mysql" named "user", if you can select * from user; you should see an ID "root" with a "Y" in each field. If that is not the case then somehow the grant permissions were changed.

Have a look at the docs HERE [mysql.com] for some common causes of access denied errors and how to fix them.

[Bolotomus]

i'm logged in as root. I don't have any permissions anymore as root.

Well, root doesn't have permission problems. But in this case, you're logged in as root, then you are connecting to the MySQL daemon which probably isn't (and certainly ought not) be running as root.