MySQL Open remote connection

When MySQL is installed, it is only locally connected by default.

Mysql-u Root-p MySQL>Use mysql; MySQL>Select 'Host'From user where user='Root'; MySQL>update User Set host ='%'where user ='Root'; MySQL>flush privileges; MySQL>Select 'Host'From user where user='Root';

The first sentence is to log in as the user root with permissions
Second sentence: select MySQL Library
The third sentence: View the host value of the user table in the MySQL library (hosts/IP names that can be accessed by the connection)
Clause Four: Modify the host value (increase the hostname/IP address with the wildcard%), or you can directly add
Clause five: Refresh MySQL system permissions related table
The sixth sentence: when you re-view the user table, there are modifications.
Restart the MySQL service to complete.

MySQL Open remote connection