Shulou(Shulou.com)06/01 Report--

Editor to share with you how to forget your password to log in to phpmyadmin. I hope you will gain a lot after reading this article. Let's discuss it together.

Phpmyadmin forgot his password and modified it with the following code:

1. Stop the mysql service:

/ etc/init.d/mysql stop

two。 Skip verification to start MySQL

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

3. Ready to reset the new password

/ usr/local/mysql/bin/mysql-u root mysql

4. Reset the new password

Update user set authentication_string = Password ('new password') where User = 'root'

5. Update permissions

Flush privileges

6. Quit

Exit

7. Restart MYSQL

Killall mysqld/etc/init.d/mysql start finished reading this article, I believe you have a certain understanding of how to forget your password to log in to phpmyadmin, 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.