I have a MySql server instance in Amazon EC2. In my.cnf
If I write bind-address = 127.0.0.1
, server can starts.
But If I write bind-address = SERVER_IP
, it gives Bind error.
So to connect this server remotely (because I want to use it for development in my local workspace), what should I do?
Best Answer
You could bind to address 0.0.0.0. This makes MySQL listen on every IP.
BUT keep in mind that you might have to GRANT usage to the IP you are connecting from like
Just as a small sidenote: You could use Amazon Relational Database Service if you just want to have a MySQL database in the cloud