We have a MySQL database server which is running on a Amazon Linux Instance which we would like to connect to remotely.
We have set the access for the port 3306 for our LAN gate way IP in the AWS security group.
We have executed the following command to grant access to our IP from where we will connect the database and the output as follows
GRANT ALL PRIVILEGES ON *.* TO 'root'@'our IP Address' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec)
Still we are getting the following error message while trying to connect the database using MySQL administrator tool:
Host: Our IP address where MySQL server runs User : root Password: Our password MySQL Error: Could not connect to the specified instance. MySQL error number 2003 Can't connect to MySQL server on 'MySQL server IP Address'(10060)
How could we solved this problem?