How to install mysql on centos and set up remote access

$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

$ sudo yum install mysql-server

$ mysql -u root

$ sudo chown -R root:root /var/lib/mysql

$ service mysqld restart

$ mysql -u root //Press Enter directly to enter the mysql consolemysql > use mysql;
mysql > update user set password=password('123456') where user='root';
mysql > exit;

Log in to mysql as root user on this machine:
mysql -u root -p "youpassword" 
To perform authorization operations:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
Reload the authorization table:
FLUSH PRIVILEGES;
Exit the mysql database:
exit

Log in to mysql as root user on this machine:
mysql -u root -p "youpassword" 
To perform authorization operations:
GRANT ALL PRIVILEGES ON *.* TO root@"172.16.16.152" IDENTIFIED BY "youpassword" WITH GRANT OPTION;
Reload the authorization table:
FLUSH PRIVILEGES;
Exit the mysql database:
exit

Log in to mysql as root user on this machine:
mysql -u root -p "youpassword" 
To perform authorization operations:
GRANT select，insert，update，delete ON *.* TO root@"172.16.16.152" IDENTIFIED BY "youpassword";
Reload the authorization table:
FLUSH PRIVILEGES;
Exit the mysql database:
exit

REVOKE privileges ON database[.table name] FROM user-name;
For a specific example, first log in to mysql locally:
mysql -u root -p "youpassword" 
To perform authorization operations:
GRANT select，insert，update，delete ON TEST-DB TO test-user@"172.16.16.152" IDENTIFIED BY "youpassword";
Then delete the authorization operation:
REVOKE all on TEST-DB from test-user;
****Note: This operation only clears the user's authorization permissions for TEST-DB, but the user "test-user" still exists.
Finally, clear the user from the user table:
DELETE FROM user WHERE user="test-user";
Reload the authorization table:
FLUSH PRIVILEGES;
Exit the mysql database:
exit

Global management permissions: 
FILE: Read and write files on the MySQL server. 
PROCESS: Display or kill service threads belonging to other users. 
RELOAD: Reload access control lists, refresh logs, etc. 
SHUTDOWN: Shut down the MySQL service.
Database/table/column permissions: 
ALTER: Modify existing data tables (such as adding/deleting columns) and indexes. 
CREATE: Create a new database or table. 
DELETE: Deletes records from a table. 
DROP: Delete a table or database. 
INDEX: Create or delete an index. 
INSERT: Add records to the table. 
SELECT: Display/search records of a table. 
UPDATE: Modify existing records in the table.
Special permissions: 
ALL: Allows you to do anything (same as root). 
USAGE: Only login is allowed - nothing else is allowed.