170424. mysql privilege control-allows users to connect remotely

MySQL for security, by default users are allowed to log on locally only, but in this case, you still need to use the user for remote connection, so that they can be remotely required to do the following:

Allow the root user to remotely log in anywhere and have any permissions to the library

Here's how:

In this machine first use root user login mysql:mysql-u root-p "Youpassword" for authorization operation:

Mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION;

Overload Authorization Table:

FLUSH privileges;

To exit the MySQL database:

Exit

Second, allow the root user to telnet in a specific IP, and have all the library operation rights, the following: In this machine first use the root user login mysql:mysql-u root-p "Youpassword" for authorization operation: Grant all Privileges on * * to [email protected]' 172.16.16.152 ' identified by ' Youpassword ' with GRANT OPTION; Overload Authorization Table: FLUSH privileges; Exit MySQL Database: Exit

Third, allow the root user to telnet in a specific IP, and have all the library-specific operation rights, the following: In this computer first use the root user login mysql:mysql-u root-p "Youpassword" for authorization operation: Grant SELECT, Insert,update,delete on * * to [E- Mail protected]"172.16.16.152" identified by "Youpassword"; Overload Authorization Table: FLUSH privileges; Exit MySQL Database: Exit

Iv. Remove user authorization, need to use the REVOKE command, the specific command format is: REVOKE privileges on database [. Table name] from User-name; Specific example, first in the native login mysql:mysql-u root-p "Youpassword" for authorization operation: Grant Select,insert,update,delete on test-db to [email protect Ed]"172.16.16.152" identified by "Youpassword"; Then delete authorization operation: REVOKE all on test-db from Test-user; Note: This action only clears the user's authorization rights for TEST-DB, but this "test-user" user still exists. Finally clear the user from the user table: DELETE from user WHERE user= "Test-user"; Overload Authorization Table: FLUSH privileges; Exit MySQL Database: Exit

V. MySQL permissions detailed classification: Global Administrative permissions: file: Read and write files on the MySQL server. PROCESS: Displays or kills service threads belonging to other users. RELOAD: Overloads the Access Control table, refreshes the log, and so on. SHUTDOWN: Turn off the MySQL service. Database/data Table/Data column permissions: Alter: Modifies an existing data table (for example, add/Remove Columns) and index. Create: Create a new database or data table. Delete: Deletes the record for the table. Drop: Deletes a data table or database. Index: Establish or delete the indexes. INSERT: Adds a table record. SELECT: Displays/searches the table's records. UPDATE: Modifies a record that already exists in the table. Special permissions: All: Allow to do anything (as root). USAGE: Only allow login-nothing else is allowed.

170424. mysql privilege control-allows users to connect remotely