MySQL connection ERROR 2003 (HY000): (110)

Question

I have searched and seen a lot of questions and answers for this error but none of them worked for me. I have my MySQL in my laptop via Xampp and wanted to connect my Raspberry Pi to it using a direct LAN connection (ethernet cable). Whenever I enter mysql -u root -p -h 192.168.1.47on my Raspberry pi, after typing my password, there is a long pause, then the error ERROR 2003 (HY000): Can't connect to MySQL server (110) shows up. Any help please? If you need more information, just ask and tell me what commands to input to show them, I'm still a beginner.

Also, I have commented the bind-address in the my.cnf but still have this error.

score 0 · Answer 1 · edited May 23 '17 at 11:57

0

What you want to establish is a remote connection. The default configuration of MySQL doesn't allow it. It's best to configure MySQL that it allows remote connection. Here is an other SO question with detailed answer about configuring MySQL to allow remote connection from the Raspberry Pi device to a MySQL server.

Also, don't forget to check the firewall rules from your computer.

edited May 23 '17 at 11:57

Community

1
1

answered Jan 11 '15 at 09:58

KarelG

5,176
4
33
49

Thanks, going to read the SO question after school. About the firewall, does disabling it enough? – shindonism Jan 12 '15 at 14:32

MySQL connection ERROR 2003 (HY000): (110)

1 Answers1