Problem on remote MySQL DB server connection
Hi Digital Oceans,
I’ve two ubuntu 16.04 server configured with this tutorial. The first one (Called A) is the MySQL DB server and the second one (Called B) is the Laravel based server. I wanna use server A as DB of server B, So in the server B, I’ve changed the bind-address to 0.0.0.0 and created same DB users on both servers, but when I tried to connect server A with this code:
mysql -h <server-A-IP> -u <user>
I got this error:
ERROR 2003 (HY000): Can't connect to MySQL server on '126.96.36.199' (111)
Could you help me ?
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.×