B.Bus B.Bus - 6 months ago 25
MySQL Question

phpMyAdmin access denied

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.

Answer

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;