Ways to allow remote users to log in to access MySQL

You need to manually increase the number of users who can access the database remotely.

Method one, log in to MySQL locally, change the "host" entry in the "User" table in the "MySQL" Database, and replace "localhost" with "%"

#mysql-U root-proot
Mysql>use MySQL;
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>select host, user from user;
Method two, direct authorization (recommended)

To use the root user from any host, password: youpassword (your root password) to connect to the MySQL server:

# mysql-u Root-proot
Mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION;

After the operation, remember to perform the following command refresh permissions

FLUSH Privileges

Ways to allow remote users to log in to access MySQL