I recently installed LAMP on Ubuntu 13.04(32-bit) but forgot my phpMyAdmin password. How can I reset its password without re-installing it?
Simply change or reset your MySQL root password by doing the following:
Stop the MySQL server
sudo service mysql stop
sudo mysqld --skip-grant-tables &
Login to MySQL as root
mysql -u root mysql
Change MYSECRET with your new root password
UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;
sudo pkill mysqld
sudo service mysql start
Login to phpmyadmin as root with your new password
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
There is a workaround on Debian (Ubuntu, Mint, etc.) where there is a second admin account automatically generated by the system called
You can see (and should not change) its password via
sudo nano /etc/mysql/debian.cnf
It is possible (sure on Ubuntu 16.04) to use that account both in phpMyAdmin as well as in the command line
mysql -u debian-sys-maint -p
The account has exactly the same privileges as phpMyAdmin's / MySQL's root.