First, rebuilding Local Users:
#vi/etc/my.cnf
[Mysqld]
Skip-grant-tables
# service MySQL Restart
Shutting down MySQL. Done
Starting MySQL.
# mysql-uroot-p
Enter Password:
mysql> INSERT into Mysql.user (host, user, Password,ssl_cipher,x509_issuer,x509_subject) values (' localhost ', ' root ' , password (' root '), ', ', ', ');
Query OK, 1 row Affected (0.00 sec)
mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)
Mysql> Grant all privileges on * * to ' root ' @ ' localhost ' identified by ' root ' with GRANT option;
Query OK, 0 rows Affected (0.00 sec)
Mysql>
Vi/etc/my.cnf
[Mysqld]
#skip-grant-tables
# service MySQL Restart
Shutting down MySQL.
Starting MySQL.
Third, rebuild the remote user by local User:
Mysql-uroot-proot
Mysql> select User,host from Mysql.user;
+----------+-----------+
| user | Host |
+----------+-----------+
| Root | localhost |
+----------+-----------+
5 rows in Set (0.00 sec)
Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT option;
Query OK, 0 rows Affected (0.00 sec)
Mysql> select User,host from Mysql.user;
+----------+-----------+
| user | Host |
+----------+-----------+
| Root | % |
| Root | localhost |
+----------+-----------+
Delete the root user of MySQL, rebuild the local user and remote user