Connect to mysql on Amazon EC2 from a remote server
I want to connect to db on EC2 from my local machine, I am not able to do and have tried everything- I am using this command to connect to EC2:
mysql -uUSERNAME -hEC2_IP -pPASSWORD
This error is generated
ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (110)
I have modified my.cnf with
skip networking
bind-address = 0.0.0.0
Still not able to connect to the database
Answer
as mentioned in the responses above, it could be related to AWS security groups, and other things. but if you created a user and gave it remote access '%' and still getting this error, check your mysql config file, on debian, you can find it here: /etc/mysql/my.cnf and find the line:
bind-address = 127.0.0.1
and change it to:
bind-address = 0.0.0.0
and restart mysql.
on debian/ubuntu:
/etc/init.d/mysql restart
I hope this works for you.