Error #1045 Access Denied in PhpMyAdmin

Question

Basically I changed the password of MySQL via CMD and after that when I tried to visit the phpmyadmin page it shows me Error #1045 Access Denied.

I would like to how to fix this problem. Thanks in advance.

score 10 · Answer 1 · edited Jan 09 '12 at 18:19

10

Go to phpMyAdmin folder (in my case it is C:\wamp\apps\phpmyadmin3.2.0.1). In the file config.inc.php change the line

$cfg['Servers'][$i]['auth_type'] = 'config'

to

$cfg['Servers'][$i]['auth_type'] = 'cookie'

Now the password will be asked on your first visit of the phpMyAdmin page

edited Jan 09 '12 at 18:19

musefan

answered Jan 09 '12 at 18:16

Dmitro

Thank you, this helped me a ton when I had a previous MySQL installation I wanted to use instead of the one bundled with WAMP. – Amarok Mar 28 '12 at 16:33

score 5 · Answer 2 · answered Nov 14 '12 at 16:39

5

you have to change the database password value in C:\wamp\apps\phpmyadmin3.4.5\config.inc.php into your MySQL database password

ex:- $cfg['Servers'][$i]['password'] = 'yourMySQLpassword';

answered Nov 14 '12 at 16:39

Dinidu Hewage

score 2 · Answer 3 · answered Mar 13 '11 at 04:56

2

Simply, clear your cache and refresh the page. That should help you out!

answered Mar 13 '11 at 04:56

CD_mmp

score 0 · Answer 4 · answered Mar 13 '11 at 03:20

0

You might need to change the password in the PPHMyAdmin config-db.php file.

answered Mar 13 '11 at 03:20

Ewan Heming

4 Answers4