Mysql – Remote Mysql in EC2 instance

amazon ec2MySQL

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

GRANT USAGE ON databse.table TO 'username'@'host';

Just as a small sidenote: You could use Amazon Relational Database Service if you just want to have a MySQL database in the cloud