centos 7 mysql随机密码_centos 7系统下重置mysql 5.7 root密码的步骤

mysql5.7版本之后，与mariadb不同，在安装之后，在启动之时，会进行自动随机密码的设定，所以在systemctl start mysqld之后，会出现mysql -uroot -p无法登陆的情况

mysql root原始密码查看

实际上mysqld在启动时，会自动设定root密码的，可以在其相关日志里面查看到，如下:

[root@bogon ~]# grep password /var/log/mysqld.log

2017-07-31T10:31:57.368883Z 1 [Note] A temporary password is generated for root@localhost: TjcrBm.j,7eU

2017-07-31T10:32:30.201882Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)

2017-07-31T10:34:40.233539Z 0 [Note] Shutting down plugin 'validate_password'

2017-07-31T10:34:41.483983Z 0 [Note] Shutting down plugin 'sha256_password'

2017-07-31T10:34:41.483990Z 0 [Note] Shutting down plugin 'mysql_native_password'

mysql root的初始密码为TjcrBm.j,7eU(每人情况不一样，具体值在mysql日志中查看)

mysql密码重置

当然有些人可能是root密码真忘记了，那样可以通过mysql免密码登陆

在其配置文件/etc/my.cnf中加入skip-grant-tables=1即可

[root@bogon ~]# grep -v ^# /etc/my.cnf | grep -v ^$

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

symbolic-links=0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

skip-grant-tables=1

然后重启mysql，使用mysql命令即可进入

[root@bogon ~]# systemctl restart mysqld

[root@bogon ~]# ss -tnl

State Recv-Q Send-Q Local Address:Port Peer Address:Port

LISTEN 0 128 127.0.0.1:9000 *:*

LISTEN 0 128 *:111 *:*

LISTEN 0 128 *:80 *:*

LISTEN 0 128 *:22 *:*

LISTEN 0 100 127.0.0.1:25 *:*

LISTEN 0 80 :::3306 :::*

LISTEN 0 128 :::111 :::*

LIST