How to configure whitelist access in mysql

Steps to configure whitelist access in mysql

1. Log in

mysql -uroot -pmysql

2. Switch to mysql database

use mysql;

3. View users with whitelist permissions

select Host,User from user;

4. Specify the IP address that has permission to access MySQL

GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';

If you don't have a password, leave it blank.

GRANT ALL ON *.* to root@'192.168.1.4' ;

The ip behind @ is the specified whitelist ip

5. Delete the permissions of whitelisted users

DELETE FROM user WHERE User='username' and Host='host';

6. Refresh

After modifying permissions, you need to refresh them to take effect

FLUSH PRIVILEGES;

mysql ip whitelist using wildcard

Today, I want to let MySQL add IP addresses like 192.168.*.* to the whitelist.

When I use 192.168.%.%, mysql reports an error

Error: 192.168.%.% is not a valid remote host

If you use a fixed IP such as 192.168.0.1, no error will be reported.

After some research, I found that the correct way to write it should be to add the subnet mask 192.168.0.0/255.255.0.0, so that access from the entire Class B subnet is allowed.

The above is my personal experience. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.