"Mysql" modifies the root password and creates an account with the same privileges as root

You may want to change the root password because you are not able to replace the server password of the network project with the MySQL database password on the server, and you may replace the ctrl+h with the other database-independent fields. This has led to a more non-starter project.

In addition, in order to have a local and root-like account to participate in testing, do small demo, so also need to create a local with the same permissions as root account.

First you have to open the MySQL command line client.

First, modify the original installation of the root account password

Similarly, you can change the password of other accounts,

Enter the following statement in the command line:

UPDATE mysql.user SET password=password (' New password ') WHERE user= ' root '; FLUSH privileges;

Second, create an account with the same privileges as root

Enter the following statement in the command line:

CREATE USER ' account ' @ '% ' identified by ' password '; GRANT all privileges on * * to ' account ' @ '% ' identified by ' password ' with GRANT OPTION max_queries_per_hour 0 Max_connections_per_hou R 0 Max_updates_per_hour 0 max_user_connections 0;

"Mysql" modifies the root password and creates an account with the same privileges as root