MySQL Common SQL statements

• Permissions

1. Revoke permissions
   Revoke all on * * from ' root ' @ ' 192.168.0.197 ';

2. Revoke permissions
   Revoke all on * * from ' xx_db ' @ '% ';

3. 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