参考答案：
正常状态：
[root@web01 data]# mysql -uroot -p123456 Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 75 Server version: 5.6.34 Source distribution Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user,host from mysql.user; +-----------+--------------------------+ | user | host | +-----------+--------------------------+ | root | 127.0.0.1 | | wordpress | 172.16.1.0/255.255.255.0 | | root | ::1 | | | localhost | | root | localhost | | | web01 | | root | web01 | +-----------+--------------------------+ 7 rows in set (0.00 sec)
管理员用户被误删除后：
mysql> drop user root@localhost; Query OK, 0 rows affected (0.07 sec) mysql> select user,host from mysql.user; +-----------+--------------------------+ | user | host | +-----------+--------------------------+ | root | 127.0.0.1 | | wordpress | 172.16.1.0/255.255.255.0 | | root | ::1 | | | localhost | | | web01 | | root | web01 | +-----------+--------------------------+ 6 rows in set (0.00 sec)
解决：
需要使用root@127.0.0.1用户登录系统(无密码)，再创建root@localhost
[root@web01 data]# mysql -h 127.0.0.1 -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 80 Server version: 5.6.34 Source distribution Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> mysql> select user,host,password from mysql.user; +-----------+--------------------------+-------------------------------------------+ | user | host | password | +-----------+--------------------------+-------------------------------------------+ | root | web01 | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | | | | web01 | | | wordpress | 172.16.1.0/255.255.255.0 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | +-----------+--------------------------+-------------------------------------------+ 6 rows in set (0.00 sec) mysql> grant all on *.* to root@localhost identified by '123456' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye
恢复正常
[root@web01 data]# mysql -uroot -p123456 Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 81 Server version: 5.6.34 Source distribution Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user,host from mysql.user; +-----------+--------------------------+ | user | host | +-----------+--------------------------+ | root | 127.0.0.1 | | wordpress | 172.16.1.0/255.255.255.0 | | root | ::1 | | | localhost | | root | localhost | | | web01 | | root | web01 | +-----------+--------------------------+ 7 rows in set (0.00 sec)
备注
今天是每日一题陪伴大家的第113天，期待你的进步。
对于题目和答案的任何疑问，请在博客评论区留言。
往期题目索引
http://lidao.blog.51cto.com/3388056/1914205
本文转自 李导 51CTO博客，原文链接:http://blog.51cto.com/lidao/1959488