Page 1 of 1

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

PostPosted: 16. January 2018 21:49
by 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?

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

PostPosted: 16. January 2018 23:50
by 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.

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

PostPosted: 17. January 2018 06:16
by ItzYeho
Thank you so much. I got back in my database.

~Thread locked - Do not reply~