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 localhost/phpmyadmin/ and at the top where Database , SQL etc are being listed, click Users and then click Change password
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