Friday, March 14, 2008

When adding a MySQL database to a domain it fails and I get 'Access denied for user: 'root@[ServerName]' (Using password: YES) ' in the logs

Go to the MySQL Service in Helm here:
Home > System Settings > Servers > Your Server > MySQL Service
Make sure the user you have set is root, and enter the correct password for the MySQL root account into the appropriate field and click Save.
*This needs to be correct, so check it by trying to log into MySQL with it. To test in the command prompt, cd into the directory where the MySQL binaries are installed, this is usualyy in c:mysqlbin and run the following command to attempt to login with the root password you set:
mysql -uroot -p
You should now be able to add MySQL databases through Helm if you are able to login successfully from the command prompt.

No comments: