The method of modifying mysql password by lamp

This article will explain in detail the method of lamp changing mysql password for you. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Lamp changes the mysql password by first stopping the MySQL service, then skipping verification to start MySQL;, then changing the password with the command "PASSWORD ('new password') where USER='root';", and finally restarting mysql.

1. 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

OK is done in this way. If you feel so complicated, you can use the second method.

This is the end of the method for lamp to change the mysql password. I hope the above content can be helpful to everyone and learn more knowledge. If you think the article is good, you can share it for more people to see.