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

This article is about how phpmyadmin resets passwords. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

PhpMyAdmin is a PHP-based, Web-Base-based MySQL database management tool on the host of the website, is a free Web application, provides a convenient GUI for the use of MySQL database management system, and allows managers to use Web interface to manage MySQL database.

PhpMyAdmin has all the common features that you might need to develop MySQL-based applications or Web sites. It is the most popular MySQL management tool used by millions of users around the world and has won numerous awards and honors.

How does phpMyAdmin reset my password?

1. Stop the mysql service:

/ etc/init.d/mysql stop

2. Skip verification and start MySQL

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

3. Prepare 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, thank you for your reading! This is the end of the way to reset the password for phpmyadmin. I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.