aws linux server, ubuntu, remote connection mysql, ERROR 2003 (HY000): Can not connect to mysql server on

Reference : http://www.voidcn.com/article/p-pnqmggwm-bqy.html

1. If you use the aws server, enter the aws console, find the security group that runs the instance, edit the inbound security group, and add the rules. Select the rule MYSQL / Aurora, the port is set to 3306, save

Unbind the address to allow access from the extranet. Edit /etc/mysql/mysql.conf.d/mysqld.cnf Find bind-address = 127.0.0.1, add # in front of it, comment the line.

3. Log in to the database, execute the following code

GRANT  ALL  PRIVILEGES  ON *. * TO  'username' @ '%' IDENTIFIED BY 'password' WITH GRANT OPTION ; FLUSH PRIVILEGES ;      
 

The first line of code to create user username, password is set to password, and allow access from all domain names, the second line of code for the update permissions.

If you change existing users to allow remote access You can modify the mysql database user table, the default field Host content 'localhost' changed to '%'.

Set root to use external network access;

USE mysql; 
UPDATE  user  SET Host = '%' where User = 'root' ; FLUSH PRIVILEGES ;