How to configure Mysql to allow remote access in Linux

How to configure Mysql to allow remote access in Linux

The procedure is very simple. The procedure is as follows:

1. Go to mysql:

/Usr/local/mysql/bin/mysql-u root-p

2. Use the mysql database:

Use mysql;

3. view the user table:

SELECT 'host', 'user' FROM User;

4. Update the user table:

UPDATE user SET 'host' = '%' WHERE 'user' = 'root' LIMIT 1;

5. Force refresh permission:

Flush privileges;

After completing the preceding steps, you can connect to the database remotely.

UPDATE user SET 'host' = '%' WHERE 'user' = 'root' LIMIT 1;

% Indicates allow remote access from all ip addresses. If you need to specify a specific ip address, write the specific ip address.

KO...