Configure MySQL to allow remote access under Linux

The operation is very simple, just 5 steps, as follows:

1. Go to MySQL:

?

1	/usr/local/mysql/bin/mysql -u root -p

2. Use the MySQL library:

?

1	use mysql;

3. View the user table:

?

1	SELECT`Host`,`User` FROMuser;

4. Update the user table:

?

1	UPDATEuser SET `Host` = ‘%‘ WHERE `User` = ‘root‘LIMIT 1;

5. Force Refresh Permissions:

?

1	flush privileges;

Complete the above steps to connect to the database remotely, the key sentence above is

?

1	UPDATEuser SET `Host` = ‘%‘ WHERE `User` = ‘root‘LIMIT 1;

Where% means to allow all IP remote access, if you need to specify a specific IP to write a specific IP can be

KO ...

Configure MySQL to allow remote access under Linux