Create User _ mysql in MySQL

Mysql creates user bitsCN.com

Grant all privileges on *. * TO username @ '%' identified by "password"

Assign the access permission to all databases of remote username.

Password is used for accessing username from any table in any database.

1 grant all privileges on test_db. * TO user1@192.168.1.3 identified by "password"
2 grant all privileges on test_db. * TO user2@192.168.1. % identified by "password"
3 grant all privileges on test_db. * TO user3@192.168.1.0/10 identified by "password"

Obviously, the first sentence is that user user1 can only be accessed on 192.168.1.3. The second sentence is that it can be accessed within the 192.168.1 network segment. The third sentence is ip 0-10.

Delete a user:

Delete from user WHERE User = "username" and Host = "localhost ";

Don't forget this sentence.

Flush privileges;

BitsCN.com