How to reset and view phpmyadmin password

mply change or reset your MySQL root password by doing the following:

1. Stop the MySQL server

   sudo service mysql stop
   

2. Start mysqld

   sudo mysqld --skip-grant-tables &
   

3. Login to MySQL as root

   mysql -u root mysql
   

4. Change MYSECRET with your new root password

   UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;
   

5. Kill mysqld

   sudo pkill mysqld
   

6. Start mysql

   sudo service mysql start
   

7. Login to phpmyadmin as root with your new password

Or

You don’t actually need to reset your username and password, if you can see them.

In your terminal window, type:

sudo -H gedit /etc/dbconfig-common/phpmyadmin.conf

This will open your phpmyadmin configurations.

There, you will see your username under dbc_dbuser='your_username' and password under dbc_dbpass='your_password'.