As per my understanding, there are two main things to check before connecting to a remote mysql db server.
1. Bind address. 2. Grant privileges.
I was able to connect to a remote mysql db server from my Mac, it was easy (
mysql -uroot -h x.x.x.x -p)
Imagine a scenario for my own learning, I want to connect to a mysql db instance on my Mac from a remote server. Imagine I am logging into this remote linux machine from my Mac and trying to connect to my own Mac db server?
mysql -uroot -h x.x.x.x -p
is raising an error
2003 mysql cannot connect 10060 cannot connect to the x.x.x.x server. It is similar to the reverse proxying while connecting to the local machine from a remote one, can someone direct to right resource (if there is a similar question please comment) which can help me figure out this thing?
Go to Source