How to create an account and Set permissions for mysql in Linux

1. Grant Permissions

Description: mysql is deployed on server A. Host B on the Intranet connects to server A through client tools for database operations. Server A needs to grant host B the permission to operate mysql.

1.1 log on to mysql on server A. Assume that the mysql account on server A is root:Copy codeThe Code is as follows: mysql-u root-p

Then press enter to enter the password!

1.2 grant database operation permissions to host BCopy codeThe Code is as follows: mysql> grant usage on *. * to username@192.168.0.1 identified by 'Password ';

(Grant username@192.168.0.1 to use all the database permissions, on the host 192.168.0.1 using username Account Login, password: password)Copy codeThe Code is as follows: mysql> grant all privileges on newdb. * to username@192.168.0.1;

(Grant username@192.168.0.1 operation database newdb the highest permissions, on the host 192.168.0.1 using username Account Login, no password)

Example:Copy codeThe Code is as follows: mysql> grant all privileges on *. * to root@192.168.0.1 identified by '123 ';

(Grant root@192.168.0.1 to use all the database permissions, on the host 192.168.0.1 use root Account Login, password: 123456)

2. Remove an accountCopy codeThe Code is as follows: mysql> drop user root@192.168.0.1;

Remove the root account. In this way, the host 192.168.0.1 can no longer use the root user to operate the database on server.