Two ways to reset the root password of MySQL database using lnmp

The first method: Use Junge's one-click script to modify the MYSQL database password in the LNMP environment

One-click scripts are certainly very convenient. Specifically execute the following commands:

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

Convenient, right?

The second method: Modify through commands, as follows:

a. Stop MySQL service

Execute: /etc/init.d/mysql stop

b. Skip verification and start MySQL

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

Then:

mysql mysql -uroot //Login 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

Summarize

The above are two methods that I introduced to you about how to use lnmp to reset the root password of the MySQL database. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!