1.停止mysql服务
systemctl stop mysqld
2.mysql服务的配置文件
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
skip-grant-tables #添加这句话,这时候登入mysql就不需要密码
symbolic-links=0
3.启动mysql服务
systemctl start mysqld
4.登入mysql
mysql
5.设置密码
mysql> USE mysql ;
mysql> UPDATE user SET Password = password(‘new-password‘) WHERE User = ’root’ ;
mysql> flush privileges ;
mysql> quit
6.再把 /etc/my.cnf 中 skip-grant-tables 注释了,恢复配置文件原样。
7.停止mysql服务
systemctl stop mysqld
8.启动mysql服务
systemctl start mysqld
9.使用密码登录mysql
[root@sample ~]# mysql -u root -p 输入密码