Remote connection to MySQL

1. When you link MySQL remotely with the root user, you are prompted to "access is denied" because MySQL does not authorize its remote link.

Log on to MySQL server:

$ mysql-u root-p123456 Login Database

mysql> use MySQL

Mysql>select Host,user,password from User;

　　

Create a new user

Format: Grant permission on the database name. Table name to user @ Login host identified by "User password";

Grant Select,update,insert,delete on * * to [e-mail protected] identified by "123456";

　　

This allows you to connect remotely using the created account: Test.

2. Authorization for remote connection

Changing the value of the Mysql.user table host field to% means that you can log on to the MySQL server as the root user on any client machine, and it is recommended that you set it to% at development time.

mysql> use MySQL;
Mysql> Grant all privileges on * * to [e-mail protected] '% ' identified by "123456";

　　

This allows the machine to remotely access MySQL on the machine with the user name root password root.

Note: Change the address in the Bind-address =127.0.0.1 in the/ETC/MYSQL/MY.CNF configuration file to the current MySQL server address, then restart the service and then connect remotely.

　　

Remote connection to MySQL