MySQL Rights Management

For a user, there are three things about permissions: What permissions I have (how to view), how I delegate permissions to others (how to authorize), and how to retrieve permissions. In

There are three types of syntax that can be done in MySQL:

First, create a TIANJC user with a password of TIANJC: Create user ' TIANJC ' @ ' 192.168.1.113 ' identified by ' TIANJC ';

　　

One, Authorization: Grant

If the user TIANJC on 192.168.1.113 is granted all permissions on the database pp: Grant all privileges on pp.* to ' TIANJC ' @ ' 192.168.1.113 ' with Grant OPTION;

Two, view permissions: Show grants

See the user on 192.168.1.113 for TIANJC permissions: Show grants for ' TIANJC ' @ ' 192.168.1.113 ';

Three cancellation authorization: REVOKE

If you cancel the authorization to TIANJC: REVOKE all privileges on pp.* from ' TIANJC ' @ ' 192.168.1.113 ';

Four, delete users: Drop user

MySQL Rights Management