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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby ItzYeho » 16. January 2018 21:49

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?
ItzYeho
 
Posts: 2
Joined: 16. January 2018 21:43
XAMPP version: 3.2.2
Operating System: Windows 10 Home

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

Postby Nobbie » 16. January 2018 23:50

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.
Nobbie
 
Posts: 10145
Joined: 09. March 2008 13:04

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

Postby ItzYeho » 17. January 2018 06:16

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

~Thread locked - Do not reply~
ItzYeho
 
Posts: 2
Joined: 16. January 2018 21:43
XAMPP version: 3.2.2
Operating System: Windows 10 Home


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests