mysql> delete from mysql.user where user='';
Query OK, 2 rows affected (0.00 sec)
mysql> delete from mysql.db where user='';
Query OK, 2 rows affected (0.00 sec)
mysql> update mysql.user set password=password('123') where user='root';
Query OK, 3 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host,password from mysql.user;
+------+-----------------+-------------------------------------------+
| user | host | password |
+------+-----------------+-------------------------------------------+
| root | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| root | node11.kong.com | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| root | 127.0.0.1 | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+------+-----------------+-------------------------------------------+
3 rows in set (0.00 sec)
*注意不要不能使用passwd等缩写,password才是正确