Some commands for root and normal user empowerment and password change in MySQL

Allow the root user to log on to the universal Navicat for MySQL client:

Mysql> Grant all privileges on * * to [e-mail protected] '% ' identified by ' root ';

Query OK, 0 rows Affected (0.00 sec)

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

Change the password for the User1 user, the permission is a bit large, but do not execute the following first command, the password cannot be changed.

Mysql> Grant all privileges on * * to [e-mail protected] ' localhost ' identified by ' 123456 ';

Query OK, 0 rows Affected (0.00 sec)

mysql> Set password for [email protected]=password (' 123456 ');

Query OK, 0 rows Affected (0.00 sec)

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

Some commands for root and normal user empowerment and password change in MySQL