Enabling MySQL server to be remotely accessible in Amazon EC2

Problem

You want to make your instance’s mysql server in Amazon available remotely, and you have set the firewall setting in your security group to allow access to port 3306, but you get the following error:

Solution

You would need to edit your /etc/mysql/my.cnf file to allow access to the mysql server by changing the line:

to

Make sure that the IP used is the private ip and not the Elastic IP.
You should be able to find that in your instance control panel.