Re: MySQL Error Number 1045 Access denied

[Bill Karwin]

Here's what I'd check first:

1. Make sure you can connect using root.

mysql -h localhost --user=root --password=xxxx

Of course, use your MySQL root password, not xxxx. Note that MySQL's root has nothing to do with operating system root, and the passwords for each can be different.

2. Find these lines in the file phpMyAdmin/config.inc.php:

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'xxxx'; // MySQL password (only needed with 'config' auth_type)

3. Edit the third line and put your MySQL root password in where I've left xxxx.

Regards,
Bill K.