Bug when creating new mysql database

chatwizrd

Verified User
Joined
Jul 3, 2005
Messages
2,005
Hi I am getting the following error when anyone attempts to make a database using directadmin.

An error occurred querying the users table Access denied for user ''@'localhost' to database 'mysql'
That user already Exists

Freebsd 5.4
Mysql 4.1.14
Directadmin 1.25.5

Please help

Thanks
 
Last edited:
An error occurred querying the users table Access denied for user ''@'localhost' to database 'mysql'
That user already Exists

Which user does already exist? I see only "@localhost", must become "root@localhost".
 
If it's a root problem try:

http://help.directadmin.com/item.php?id=45


If it is a user problem then it may be that the user was creating on ssh and not on DA. Try doing an id username to see if that user account was created. If it was first delete that user in DirectAdmin then go to ssh and check if the user is still there. If he is delete the user. Create the account again via directadmin and see if that works.

If this is happening with all users then it's a mysql installation problem. reinstall mysql. If that does not work contact DirectAdmin Support.
 
This was fixed using /usr/local/directadmin/scripts/mysql.sh

Dont ask me why it would of errored out like this it was a fresh install but this did fix the errors.

Thanks
 
Back
Top