While working on a PHP project, it got to a stage that I needed to connect to my database and as you guessed: I had already forgotten my user password.
Of course I could easily create a new user with a fresh password and move on with the project, but that seemed like a shortcut that was not really appropriate for me to take.
To Change or Remove Password of Users in PhpMyAdmin: Open
PhpMyAdmin control panel
Here you can input a new password for the user you’ve forgotten its password or click No password to remove the old password and click Go at the bottom right corner
to save. As simple as my name! 🙂