LNMP resetting the MySQL database root password

The first method: Use one click of Military brother to modify the MySQL database password script in LNMP environment

One-click Scripting is definitely very handy. Specifically, execute the following command:

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

It's Convenient!
The second method: Change by command, as follows:

A. Stop the MySQL service
Execution:/etc/init.d/mysql stop
B. Skip verification to start MySQL
/usr/local/mysql/bin/mysqld_safe–skip-grant-tables >/dev/null 2>&1 &
And then:
MySQL mysql-uroot//Login
mysql> UPDATE user SET Password=password (' New Password ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
Then restart MySQL
/etc/init.d/mysql start

LNMP resetting the MySQL database root password