I'm trying to connect to a MySql 5.1 server on but the error message talks about host This is not the host i'm trying to login to. I can login using a lesser account 'XBMC'.

Here's the image of the window, and the text will follow. MySql workbench access denied but hostname doesn't match

[Window Title] MySQL Workbench

[Main Instruction] Cannot Connect to Database Server

[Content] Your connection attempt failed for user 'root' from your host to server at Access denied for user 'root'@'' (using password: YES)

Please: 1 Check that mysql is running on server 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3 Check the root has rights to connect to from your address (mysql rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for connecting from the host address you're connecting from


2 is the IP address of your PC you are running MySQL Workbench on. MySQL allows to specify addresses certain users are allowed to connect from. In your case root is not allowed to connect from

By default MySQL creates user root as 'root'@'localhost'. To remove the restriction you need to rename the user to 'root'@'%'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.