1. Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server
This error is generic, there can by various reasons for this error.
One of the reason might be that 'user' and client 'host' is not having proper privileges. Please grant the privileges by giving the following
commands from MySQL command line.
mysql> use mysql
mysql> GRANT ALL ON *.* to urUser@'[urhostname]' IDENTIFIED BY 'urpassword';
mysql> FLUSH PRIVILEGES;
Please replace 'urUser' and 'urpassword' with your own username and password.
If the connection to MySQL still does not work, make sure that networking is enabled on the MySQL database. For newer versions of MySQL, this can be achieved using the MySQL Server Instance Configuration Tool. One of the options on the tool is to enable TCP/IP networking. The tool will also allow you to specify a port (the default is 3306) and create a firewall exception.
2. Unable to Connect to any of the Specified hosts
This is a generic error. This can be caused by different reasons. Please try any of the following actions
Please check that the MySQL Server (MySQL
Service if you are running Windows) is running.
Please make sure you have turn on TCP Networking in MySQL configuration file. Please MySQL Server Instance Configuration Wizard and Enable TCP/IP networking and restart MySQL Server.
Check that you have specified the correct Port
No. Usually the MySQL Server runs on Port No. 3306. You can check the
Port Number by looking into MySQL Configuration file "My.Ini" which is located in the
same folder where MySQL software is installed
3. Access denied for user 'UserName'@'HostName' (using password: YES)
This usually occurs due to wrong password. Please supply the correct Username and Password