Mysql user management

1. View users
Use mysql;
Select * from user;
2. Add and authorize a user:
(1) Add users that can log on to any machine
Grant all privileges on dbName. * TO test @ "%" identified by "1111 ";
(2) Add a user logging on to the server 172.16.184.233
Grant all on dbName. * TO test@172.16.184.233 IDENTIFIEDBY "1111 ";
(3) Add a user to grant addition, deletion, modification, and query permissions.
Grant select, INSERT, DELETE, update on dbName. * TO test @ % IDENTIFIEDBY "1111 ";
However, this
Grant all privileges on *. * to 'test' @ 'localhost' identified by '123'
3. revoke permissions
Revoke all privileges on *. * from 'test' @ 'localhost'
4. delete a user
Use mysql;
Delete from user WHERE User = "test" and Host = "localhost ";
5. Change User Password
Use mysql;
Update mysql. user set password = password ('new password') where User = "test" and Host = "localhost ";