MYSQL Permissions Control

MySQL Authority control system includes 2 aspects:

1. Check if the user can connect

2. Check if the user has permission to perform the action

MYSQL Privilege Level:

1. Global Layer

2. Database tier

3. Surface level

4. Column level

5. Sub-Program level

Authorization command:

GRANT all privileges the on level to user name @ host identified by password; (password of authorized user)

Ex:grant all privileges on * * to ' owen_test ' @ '% ' identified by ' 100 '; (* * means all permissions for all databases)

Revoke permissions:

REVOKE all privileges from ' Owen_zeng ';

MYSQL Connection Authentication

The host here indicates where the host is allowed to connect

1. All hosts '% '

2. Exact host name or IP. Owen_zeng or 172.26.6.x

3. Use the * wildcard character, *_zeng

4. Specify a network segment 192.168.3.2/255.255.255.0