Shulou(Shulou.com)05/31 Report--

Editor to share with you how lnmp resets the root password of mysql database. I hope you will get something after reading this article. Let's discuss it together.

The first method: modify the MYSQL database password script in LNMP environment

One-click scripting must be very convenient. 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: modify it through the command, as follows:

A. Stop the 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 / / Log in mysql > UPDATE user SET Password=PASSWORD ('new password') where USER='root';mysql > FLUSH PRIVILEGES;mysql > quit

Then restart mysql

/ etc/init.d/mysql start has finished reading this article, I believe you have a certain understanding of "how lnmp resets the root password of mysql database". If you want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.