MySQL Authorized remote access

When the MySQL administration tool connects to the database, it is prone to problems that cannot be connected.

As shown in the following:

650) this.width=650; "title=" QQ picture 20150824234738.png "Src=" http://s3.51cto.com/wyfs02/M00/71/F4/wKiom1XbPIuA_ D1taac98itsv0q474.jpg "alt=" Wkiom1xbpiua_d1taac98itsv0q474.jpg "/>

In general, MySQL does not grant access to other machines or IP.

So we need to set up permissions in MySQL that can be accessed remotely

① into MySQL

Mysql>mysql-u root-p

mysql>123123 (password)

② authorize remote access and refresh the authorization form;

mysql>grant All privileges on * * to ' root ' @ '% ' identified by ' 123123 ';

Mysql>flush privileges;

③ Exit MYQL

Mysql>exit

Instead of restarting Linux or virtual machines, connect directly with the MySQL database management tool.

This article is from the "I have patience with myself" blog, please be sure to keep this source http://9607474.blog.51cto.com/9597474/1687869

MySQL Authorized remote access