Apache Friends Support Forum

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.

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

It worked thanks so much. But why did that change make the difference?

It worked and got me to the log in but none of my usernames or passwords work now? How do I fix this problem?

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!