Error #1045 Access Denied in PhpMyAdmin

php wamp mysql-error-1045
Shabir Gilkar picture Shabir Gilkar · Mar 13, 2011 · Viewed 24k times · Source

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.

Answer

Dmitro picture Dmitro · Jan 9, 2012

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

Related questions

How to send an email using PHP?

I am using PHP on a website and I want to add emailing functionality. I have WAMPSERVER installed. How do I send an email using PHP?

Read More
Fix Access denied for user 'root'@'localhost' for phpMyAdmin

I'm using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the 'root' user (with 'localhost' host) and gave it a password of 'root'. This turned out to be a big mistake that I'm trying to revert. Now when …

Read More
Running Composer returns: "Could not open input file: composer.phar"

I am new to symfony2 and reading symblog. In third chapter while trying with data-fixtures I tried the command: php composer.phar update but I got the error: Could not open input file: composer.phar So I googled a little …

Read More