在安裝完MySQL資料庫後,必須修改資料庫的預設賬号密碼,以保證資料庫的安全性,以下為操作步驟:
#mysql
mysql> use mysql;
Database changed
mysql> select user,password,host from user;
+-------+-------------------------------------------+-----------------+
| user | password | host |
| root | | localhost |
| root | | email-admin |
| root | | 127.0.0.1 |
| root | | ::1 |
| | | localhost |
| | | email-admin |
| root | | % |
檢視發現資料庫預設root賬号和空賬号都未設定密碼
修改root使用者的密碼
mysql> update user set password=PASSWORD('yourpassword') where user='root';
Query OK, 5 rows affected (0.00 sec)
Rows matched: 5 Changed: 5 Warnings: 0
删除空賬号mysql> delete from user where user='';
Query OK, 2 rows affected (0.00 sec)
mysql> select user,password,host from user;
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | localhost |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | email-admin |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | 127.0.0.1 |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | ::1 |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | % |