Skip to content
Home » MySQL » How to Resolve ERROR 2003 (HY000): Can't connect to MySQL server

How to Resolve ERROR 2003 (HY000): Can't connect to MySQL server

ERROR 2003 (HY000)

When we tried to copy the local database to a remote database, we saw ERROR 2003 (HY000).

C:>mysqldump -u root -ppassword db_name | mysql -u root -ppassword -h db2.example.com db_name
...
ERROR 2003 (HY000): Can't connect to MySQL server on 'db2.example.com' (110)

If you met the following error, it could be the firewall problem.

After opening port on Windows firewall for port 3306, we can connect remote database.

Leave a Reply

Your email address will not be published. Required fields are marked *