Shulou(Shulou.com)06/01 Report--

Mysql > grant select,insert,update,create on test.* to test@'192.168.8.%' identified by '123456'

Mysql > grant select,insert,update,create on test.* to test@'192.168.9.%' identified by '123456'

Mysql > grant select,insert,update,create on test.* to test@'192.168.20.%' identified by '123456'

The above statement authorizes all permissions of the test database to the test user, only allows the test user to log in remotely in the IP range of the three network segments 192.168.8 and 920, and sets the password of the test user to 123456

Refresh the permissions table to make its settings take effect:

Mysql > flush privileges

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.