Phpmyadmin access denied

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

Phpmyadmin access denied

Postby registereduser » 05. September 2013 22:45

I went into phpmyadmin, but there was no password set for root so I went to Users
select Root, there are 3 roots, so I set each root to have a password. But then it says
#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.

but it never has a login screen. There used to be a username/password login screen for phpmyadmin, now I can't get in to fix this.
because I need a password to change the password, but can't login because a password is required but never asked for.
:shock:
registereduser
 
Posts: 10
Joined: 15. October 2011 10:34

Re: Phpmyadmin access denied

Postby Altrea » 06. September 2013 03:43

Open \xampp\phpMyAdmin\config.inc.php in your text editor

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

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


and save the file
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 110 guests