"BUG & Problem" MySQL Remote connection failed

Problem description

Connect to the remote database with the MySQL client on the cloud host today to indicate that the connection failed. Tip the Host "62.183.38.xx" is not allow to connect the MySQL server.

Host is the IP of my extranet. Shutting down the cloud host firewall and starting the MySQL service are not valid.

Solution Solutions

After checking the information of relevant netizens, find the reason, because MySQL default does not open remote connection permissions. So open the permissions in the MySQL command line, solve the problem!

MySQL > GRANT all privileges on * * to ' root ' @ '% ' identified by ' your password ' with GRANT OPTION

This command is the root user that opens all permissions for *. * (all databases) to %(any IP)

• Resources
• Http://www.jb51.net/article/24508.htm

"BUG & Problem" MySQL Remote connection failed