ERROR 2003 (HY000): Can't Connect to MySQL Server on ‘IP Address’ (Port)

Symptoms

On the import to MySQL the following error arises: “ERROR 2003 (HY000): Can't connect to MySQL server on '128.103.100.153' (10061)”.

Cause

The MySQL server doesn't exist or IP address or port is incorrect.

Solution

Please follow the steps below to verify and fix the problem:

• Make sure that the host with such IP Address exists. Please enter the following command in the Command Shell:

ping address

where:

address - name or IP address of the MySQL host.

• Try to connect manually to MySQL Server using command:

MySQL -u 'user' -p -h 'host' -P 'port'

where:

'user' - user name;
'host' - name or IP address of host where server is installed;
'port' - MySQL port (by default 3306);

After typing the password something like in the picture below must arise:

If you can see it then connection options are correct and you can use them in the Wizard on “Target Options” page.

If you have any other questions, please contact us: support@ispirer.com