Revoke permissions
Revoke all on * * from ' root ' @ ' 192.168.0.197 ';
- Revoke permissions
Revoke all on * * from ' xx_db ' @ '% ';
Give the specified user permissions to the specified database select
Grant SELECT on xx_db to ' user_xx ' @ ' percent ' identified by "password";
Assign all permissions to the specified database to the specified user
Grant all privileges the xx_db. * to 'user_xxb ' @ '% ' identified by 'password';
Give all users all permissions on the specified database
Grant SELECT On * * to ' xx_db ' @ '% ' identified by "password";
Give all users all permissions (remote access, not restricted to native access)
Grant all privileges on * * to 'user_xx' @ '% ' identified by "password";
Permissions granted to grant
Grant all privileges on *. * to ' user_xx ' @ '% ' with GRANT OPTION
Assigning permissions to all databases to a given user
Grant Select on xx_db to 'user_xx' @ ' percent ' identified by "password";
MySQL Common SQL statements