change password of phpmyadmin in ubuntu

change password of phpmyadmin in ubuntu

If you know your current password, you don’t have to stop mysql server. Open the ubuntu terminal. Login to mysql using:

mysql -u username -p

Then type your password. This will take you into the mysql console. Inside the console, type:

> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

Then flush privileges using:

> flush privileges;