Data Loader
 

Troubleshooting Connection Problems while connecting to MySQL Server.

1. Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server


Connecting to MySQL




Solution: 

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

 

mysql tcp protocol


Solution:

This is a generic error. This can be caused by different reasons.  Please try any of the following actions

3. Access denied for user 'UserName'@'HostName' (using password: YES)

 

Access Denied for user error in MySQL 

Solution:

This usually occurs due to wrong password. Please supply the correct Username and Password