Differences

This shows you the differences between two versions of the page.

--- knowledge-base:database-migration:setup-and-troubleshooting:mysql:error-2003 [2009/08/20 13:17]
+++ knowledge-base:database-migration:setup-and-troubleshooting:mysql:error-2003 [2023/10/26 13:45] (current)
uliana.philippova created
@@ Line 1: / Line 1: @@
+\\
+[[https://www.ispirer.com|Ispirer Website]]
+[[https://www.ispirer.com/products/mysql-migration|Ispirer Capabilities: MySQL Migration]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
+====== 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:
+{{:knowledge-base:database-migration:setup-and-troubleshooting:mysql:mysql_2003_error.jpg?nolink|}}
+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: [[[email protected]]]