how to List all phpmyadmin user/pass for Linux

how to List all phpmy开发者_运维知识库admin user/pass for Linux as i forgot the DB password?

Start mysql server without authentication

mysqld_safe --skip-grant-tables

Login to mysql server

mysql --user=root mysql

reset the password of any user inclusing root

update user set Password=PASSWORD('new_password') where user='user_name';

Now start the server and use the new password.