1.修改my.cnf配置文件
添加skip-grant-tables,跳过授权表登录,重启服务
vi /etc/my.cnf
[mysqld]
skip-grant-tables
[root@localhost mysql]# service mysqld restart
Shutting down MySQL.... SUCCESS!
Starting MySQL. SUCCESS!
2.进入数据库修改密码
]# mysql
MySQL [(none)]> use mysql
MySQL [mysql]> show tables;
MySQL [mysql]> select authentication_string,user from user;
MySQL [mysql]> update user set authentication_string=password('1qaz@WSX') where user='root';
3.修改配置文件
修改配置文件,删除skip-grant-tables,删除跳过授权表登录,重启服务
vi /etc/my.cnf
[mysqld]
重启MySQL
]# service mysqld restart
Shutting down MySQL.... SUCCESS!
4.使用新的MySQL密码登录测试
]# mysql -uroot -h127.0.0.1 -P3366 -p'1qaz@WSX'