How to reset password in phpmyadmin?

I forgot my phpMyAdmin login password, how do I reset it? The following article will introduce it to you. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

phpMyAdmin is a MySQL database management tool based on PHP and structured in Web-Base mode on the website host. It is a free Web application; for using MySQL The database management system provides a convenient GUI, allowing administrators to use the Web interface to manage MySQL databases.

phpMyAdmin has all the common features you may need while developing a MySQL based application or website. It is the most popular MySQL management tool used by millions of users around the world and has won numerous awards and honors.

phpMyAdminHow to reset 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 a new password

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

4. Reset new password

update user set authentication_string = Password('新密码') where User = 'root';

5. Update permissions

flush privileges;

6. Exit

exit;

7. Restart MYSQL

killall mysqld
/etc/init.d/mysql start

Related recommendations:phpmyadmintutorial

The above is the detailed content of How to reset password in phpmyadmin?. For more information, please follow other related articles on the PHP Chinese website!