Hi,
I saw many Q&As regarding this problem. Here is what I did for troubleshooting:
I saw that the server is listening on the SQL default port: netstat -ntlp | grep 3306 tcp6 0 0 :::3306 :::* LISTEN 3092/mysqld
/etc/mysql/my.cnf was empty
IpTables was empty.
telnet <My IP> 3306 -> resulted in correct manner
I feel a little bit clueless… If someone can help I would be gracious. Also, I would be happy to understand exactly what does this error say, b/c if I try to connect with my MySQL workbench to some random IP I get a different error.
Many Thanks, Tomer.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
This is confusing indeed. Error 0 means success.
Can you add this to your
[mysqld]
section in my.cnf:Restart MySQL. Can you also post the output of this command from your workstation (not server):
Cheers
Had same problem and tried this and it worked;