Cant access PHPAdmin after passwords were added to root user

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

Cant access PHPAdmin after passwords were added to root user

Postby query123456789 » 02. April 2014 22:35

Hello,

I am new to Apache, MySQL, and PHP in general. I was told it might be easier to get started by downloading XAMPP. When I opened up my PHPAdmin for the first time I got a warning at the bottom that I was at risk because I had not assigned passwords to my root users. So I went into privileges and changed all four passwords for the root users thinking this would help. After I clicked go to change the root localhost password I went back to home. When I tried to reopen PHPAdmin I got this:
Error
MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

When I went into my config document I couldn't find anything that seemed to me, with my lack of knowledge, to be related to fixing the problem. Any help would be greatly appreciated.
query123456789
 
Posts: 3
Joined: 02. April 2014 22:26
Operating System: Windows 7

Re: Cant access PHPAdmin after passwords were added to root

Postby Altrea » 02. April 2014 23:38

Hi,

Open your \xampp\phpmyadmin\config.inc.php file in your editor

Search
Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config';


Change it to
Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'cookie';


save the file and try again to access phpmyadmin

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Cant access PHPAdmin after passwords were added to root

Postby query123456789 » 03. April 2014 01:01

It worked thanks so much. But why did that change make the difference?
query123456789
 
Posts: 3
Joined: 02. April 2014 22:26
Operating System: Windows 7

Re: Cant access PHPAdmin after passwords were added to root

Postby query123456789 » 03. April 2014 01:04

It worked and got me to the log in but none of my usernames or passwords work now? How do I fix this problem?
query123456789
 
Posts: 3
Joined: 02. April 2014 22:26
Operating System: Windows 7

Re: Cant access PHPAdmin after passwords were added to root

Postby wolfiegrl » 14. March 2015 03:05

Query, did you ever get a resolution to this? I know it's been awhile but I'm trying to solve the same issue and can't find any suggestions that fix it. Thanks!
wolfiegrl
 
Posts: 6
Joined: 12. March 2015 03:50
Operating System: Win 7 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 34 guests