How to open external network access rights for mysql

As shown below:

Mainly execute authorization commands:

Two ways

1. Allow any host to connect to the local server with user bd and password bdpw

mysql> GRANT ALL PRIVILEGES ON *.* TO 'bd'@'%' IDENTIFIED Y 'bdpw' WITH GRANT OPTION;
mysql> flush privileges;

2. Allow specific IP addresses to connect to the local server with user bd and password bdpw

mysql> GRANT ALL PRIVILEGES ON *.* TO 'bd'@'172.16.4.198' DENTIFIED BY 'bdpw' WITH GRANT OPTION; 
mysql> flush privileges;

Notice:

1. Enter the password in the Command Line Client or enter the Nivacat command line interface.

2. Input: use mysql;

3. Query host input: select user,host from user;

If there is a host value of %, execute the authorization statement directly; if not, execute step 4

4. Create a host

If there is no host value of "%", select an open user (bd) and execute

mysql> update user set host='%' where user='bd'; 
mysql> flush privileges;

5. Authorized user *.* indicates authorization of all permissions

mysql> GRANT ALL PRIVILEGES ON *.* TO 'bd'@'%' IDENTIFIED BY 'bdpw' WITH GRANT OPTION; 
mysql> flush privileges;

The above method of opening external network access rights for MySQL is all I have to share with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.