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:
First, allow the root user to telnet anywhere, and have all the library operation permissions, the following:
Log in to MySQL using the root user first:
Mysql-u root-p "Youpassword"
To authorize the 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 permissions, the following:
Log in to MySQL using the root user first:
Mysql-u root-p "Youpassword"
To authorize the operation:
Grant all privileges on * * to [email protected] ' 172.16.16.152 ' identified by ' Youpassword ' with GRANT OPTION;
Overload Authorization Table:
FLUSH privileges;
To exit the MySQL database:
Exit
Third, allow the root user to telnet in a specific IP, and have all the library-specific operation rights, the following:
Log in to MySQL using the root user first:
Mysql-u root-p "Youpassword"
To authorize the operation:
GRANT select,insert,update,delete On * * to [e-mail protected] "172.16.16.152" identified by "Youpassword";
Overload Authorization Table:
FLUSH privileges;
To exit the 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;
For specific instances, first log in to MySQL:
Mysql-u root-p "Youpassword"
To authorize the operation:
GRANT Select,insert,update,delete on Test-db to [e-mail protected] "172.16.16.152" identified by "Youpassword";
Then delete the authorization action:
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;
To exit the 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.
CentOS config mysql allows remote login