Two Methods for resetting the root password of the mysql database by lnmp: lnmpmysql

Two Methods for resetting the root password of the mysql database by lnmp: lnmpmysql

Method 1: Use June's one-click modification to the MYSQL Database Password script in the LNMP Environment

One-click script is certainly very convenient. Run the following command:

The wget http://soft.vpser.net/lnmp/ext/reset_mysql_root_password.shsh reset_mysql_root_password.sh

Convenient!

Method 2: run the following command to modify it:

A. Stop the MySQL service.

Run:/etc/init. d/mysql stop

B. Skip verification to start MySQL

/Usr/local/mysql/bin/mysqld_safe-skip-grant-tables>/dev/null 2> & 1 &

Then:

Mysql-uroot // log on to mysql> UPDATE user SET Password = PASSWORD ('new password') where USER = 'root'; mysql> flush privileges; mysql> quit

Then restart mysql

/Etc/init. d/mysql start

Summary

The above section describes two methods for resetting the root password of the mysql database through lnmp. I hope this will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!