Failed to connect to MySql database on remote Linux server from Windows GUI tool

Question

I installed the mysql database on a Linux server on Amazon EC2. It works well locally. I can go into linux field and administer mysql database

I am trying to connect a local GUI client to a remote mysql and cannot connect.

I updated the /etc/mysql/my.cnf file and changed the following:

skip-networking
bind-address            = 0.0.0.0

I still cannot connect. Any thoughts?

EDIT : I first tried bind-address = 0.0.0.0, then added skip-networking with address binding

EDIT # 2 : I made sure the security group opens on 3306. I also have other ports that work, so I don't think this is a problem with Amazon.

Answer 1

3306 ( IP). 3306 Putty/ssh, localhost .

:

grant all privileges on yourDatabaseName.* to 'yourUserName'@'localhost' identified by "yourUsersPassword";

, , . :

grant all privileges on yourDatabaseName.* to 'yourUserName'@'yourClientsIp' identified by "yourUsersPassword";