Force reset Mysql password in CentOS 7

Force reset Mysql password in CentOS 7

The security mechanism of Mysql 5.6 is enhanced. By default, a password is randomly generated for the ROOT user and stored in the/root/. mysql_secret directory of the installation user.

• (1) log on with the ROOT user and STOP the database

#/Etc/init. d/mysql stop or/etc/rc. d/init. d/mysql stop (init. d is linked to rc. d/init. d soft link)

• (2) skip the authorization table to start the Mysql server

# Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking & Ctrl + c // terminate

• (3) log on and change the Password # mysql-u root mysqlmysql> UPDATE user set password = Password ('newpassword') where USER = 'root'; mysql> flush privileges; mysql> quit

• (4) restart mysql #/etc/init. d/mysql restart

• (5) Log On As root # mysql-u root-pEnter password: mysql>

• (6) OK!