修改MYSQL默认账户密码
在安装完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;
+-------+-------------------------------------------+-----------------+
| user | password | host |
+-------+-------------------------------------------+-----------------+
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | localhost |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | email-admin |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | 127.0.0.1 |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | ::1 |
| root | *5A85E100F2A0D4AD5805DD6E3331937747369E5B | % |
最后刷新缓存,确保新的密码立即开始使用
mysql>flush privileges;
Query OK, 0 rows affected (0.01 sec)
转载于:https://blog.51cto.com/sanpi/952589