笔记：MySQL初次使用安全设置

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才是正确