Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to MySQL Request SQLWays

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:

MySQL connected shell

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to MySQL Request SQLWays

sqlways/troubleshooting-guide/mysql/import/can-not-connect.txt · Last modified: March 20, 2013, 04:14:07 AM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement