Locked myself out of MySQL - How to get back in?

[ItzYeho]

Hello fellow people.

I'm an MySQL noob in general, and I wanted to protect my database using a password. So, I generated a password and saved it, and right after I reloaded (after I clicked Save Password in MyPhPAdmin) myPhPAdmin said: Access denied for user 'root@localhost' (USING PASSWORD: NO).

Generally, I freaked out. I was going to MySQL's config in XAMPP and setting up the client password to be the same as the database's password, but it did not work. I'm getting this error message while trying to access my MySQL database through: localhost/phpmyadmin. How can I enter my password, exactly?

[Nobbie]

Edit file config.inc.php in folder phpmyydmin, search for AUTH_TYPE which is set to "config". Replace "config" by "cookie". Then again open phpmyadmin in your browser, you will get a login dialog. Enter Userid (i. e. "root") and your new password.

[ItzYeho]

Thank you so much. I got back in my database.

~Thread locked - Do not reply~