phpMyAdmin access denied

0
votes

I am using wamp server, and my phpMyAdmin page returned the following error.

Wamp server version:2.2 MySQL version:5.5.24

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I edited my config file, wamp\apps\phpmyadmin4.1.14\config.inc.php to:

$cfg['Servers'][$i]['user'] = 'root'; 
$cfg['Servers'][$i]['password'] = '';

But it did not solve the problem. Any help will be appreciated.

1
mysqlphpmyadminwampwampserver
Bt default the username = root and the password = nothing(leave it blank) - RiggsFolly
When you say I edit wamp\apps\phpmyadmin4.1.14\config.inc.php what did you change?? - RiggsFolly
Do you get the Username / Password prompt, or does it attempt to log in without entering a Username or Password? - Admiral Noisey Bottom
Verify that you are using right credentials(set password if its there), if its not works still, you may show your connection code so some can identify issue if its in code - Rupal Javiya
If you dont communicate with us, people will get bored and go and do something else. and this question will be forgotten about - RiggsFolly

1 Answers

2
votes

try this in your phpmyadmin config.inc.php :- 

    $cfg['Servers'][$i]['verbose'] = 'localhost';
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['port'] = '3306';
    $cfg['Servers'][$i]['socket'] = '';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '';
    $cfg['Servers'][$i]['AllowNoPassword'] = true;