CentOS 7 + MySQL 5.7.13 reset the root password of the database

CentOS 7 + MySQL 5.7.13 reset root password step:

# vi/etc/my.cnf # [mysqld] under Skip-grant-tables content before adding #

# Mysql-uroot-p Enter Enter continuously

# use MySQL

# Update Mysql.user Set Authentication_string=password (' Redhat ') where user= ' root ';

# Grant all privileges on * * to [email protected] '% ' identified by ' Redhat '; (Authorization, otherwise navicat cannot log on to the database).

# vi/etc/my.cnf # [mysqld] get rid of the content before Skip-grant-tables

#systemctl status Mysql.service Restart the MySQL database service.

You can log in to the database again.

This article from "to Guanshuxian" blog, declined reprint!

CentOS 7 + MySQL 5.7.13 reset the root password of the database