Data Loader

Troubleshooting Connection Problems while connecting to MySQL Server.

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

Connecting to MySQL


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';


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


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 


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


4. Client does not support authentication protocol requested by server; consider upgrading MySQL client

mysql 8 connection problem


This issue will come if you are connecting to MySQL 8. In MySQL Version 8.0 MySQL has introduced a new authentication protocol call caching_sha2_password. This authentication is enabled by default and to connect to MySQL 8.0 instance the client should also be using MySQL 8 libraries.

If you are using Data Loader version 4.8.x or earlier then you might face this error as it uses old MySQL Libraries.


Upgrade to Data Loader version 4.9 it uses the latest MySQL Connection libraries.


If you want to stick with earlier Data Loader Version then you can follow the following workaround.

Step 1. Create a new user in MySQL 8 database

mysql> create user user1@localhost identified by 'passxxx'

Step 2. Grant required privileges

mysql> GRANT ALL ON *.* to user1@localhost IDENTIFIED BY 'passxxx'; 

Step 3. Change authentication method for this user to old

 mysql> ALTER USER user1@localhost IDENTIFIED WITH mysql_native_password BY 'passxxx';

Now you can connect to MySQL 8.0 with this user "user1" in Data Loader 4.8.x or earlier.

Top tools for converting and Synchronizing MS SQL Server to MySQL