1.登陆mysql
[root@localhost ~]# mysql -u root
[root@localhost ~]# mysql -uroot -p
2.切换到存储用户名和密码的数据库
执行
use mysql
提示
eading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed
3.修改密码,适用password()函数进行加密,实际上就是执行sql语句来更新指定用户的密码
[mysql]> update user set password=password('新密码') where user='要更新密码的用户名';回车
Query OK, 0 rows affected (0.00 sec)
Rows matched: 5 Changed: 0 Warnings: 0
4.刷新用户权限列表
flush privileges;
5.退出mysql登陆
quit
6.重启mysql服务
service mysqld restart