MySQL forgot password how to modify

First step: Stop the Service

/etc/init.d/mysqld stop

Step two: Add parameters to start the service

Cd/application/mysql/bin/mysqld_safe--skip-grant-table--user=mysql--skip-networking &

This mode: No password login network users can not log on only local login and authorization related commands can not be executed

Step three: Change the password

# mysqlmysql> Update mysql.user set Password=password (' 123 ') where user= ' root ' and host= ' localhost ';mysql> flush PR Ivileges;

MYSQL5.7 Modify password Modify field  authentication_string

Fourth step: Exit the Restart Service

/etc/init.d/mysqld restart

Fifth Step: Login Verification

Mysql-uroot-p123

This password changes successfully!

MySQL forgot password how to modify