B.Bus B.Bus - 2 years ago 204
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 Source

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;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download