Page 1 of 1

Phpmyadmin access denied

PostPosted: 05. September 2013 22:45
by registereduser
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:

Re: Phpmyadmin access denied

PostPosted: 06. September 2013 03:43
by Altrea
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