Error creating the database

[RokiZs]

Hello dear DirectAdmin members.

I need you'r help:
I just fresh reinstalled MySQL and i when i'm trying to create databese ( using http://my-domain.eu:2222/CMD_DB ) i get this error:

Error creating the database

Details

An error occurred querying the users table SELECT command denied to user ''@'localhost' for table 'user'
That user already Exists

How i can fix this?

 

[zEitEr]

Hello,

I've never seen such an error, so just a quick guess. Make sure you've got not empty /usr/local/directadmin/conf/mysql.conf with:

user=da_admin
passwd=secret_pass_here

where secret_pass_here should be da_admin's password to connect to MySQL server.

 

[RokiZs]

Same

Hello,

I've never seen such an error, so just a quick guess. Make sure you've got not empty /usr/local/directadmin/conf/mysql.conf with:

user=da_admin
passwd=secret_pass_here

where secret_pass_here should be da_admin's password to connect to MySQL server.

yea there was no password, but now it shows:

Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: NO)
Repair guide: http://help.directadmin.com/item.php?id=45

. But i got set the pass in the file...

 

[scsi]

Then its not the right password.

 

[zEitEr]

Are you sure the password is valid? Are you succefull to connect to MySQL with that password?

Please note if for any reason you need root's password to connect to MySQL server you can find it here: /usr/local/directadmin/scripts/setup.txt it is a line beginning with "mysql=" there.

 

[RokiZs]

Are you sure the password is valid? Are you succefull to connect to MySQL with that password?

Please note if for any reason you need root's password to connect to MySQL server you can find it here: /usr/local/directadmin/scripts/setup.txt it is a line beginning with "mysql=" there.

yes i can connect using: mysql -uroot -p or mysql -uda_admin -p and the password is the same.

 

[zEitEr]

Make sure to have an empty new line in /usr/local/directadmin/conf/mysql.conf at the very bottom.

 

[RokiZs]

Make sure to have an empty new line in /usr/local/directadmin/conf/mysql.conf at the very bottom.

Thank you i made a new line & restarted mysql and now everything works. Once again Thank you!