phpMyAdmin Access denied with error #1045

[zayn_william]

Hello,

I have logged in to cPanel to make changes in the database, and it is showing Error #1045. Unfortunately, I cannot access phpMyAdmin. So how can I resolve the error? Please assist me with the same.

[Rex Maughan]

Hello zayn_william,


Sometimes the phpMyAdmin access denied shows error #1045 when we need to make database changes. However, you can follow the below methods to fix the phpMyAdmin access denied error,

• Firstly, navigate to the phpMyAdmin folder,

C:\wamp\apps\phpmyadmin3.2.0.1

• Now, In the config.inc.php file, you need to change the below line,

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

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

• Then, a password will be requested on your foremost browse of the phpMyAdmin page.
• Lastly, enter the password and check if it is working or not.

You can also follow the below way if the above method doesn't work for you,

• You must change the database password value in C:\wamp\apps\phpmyadmin3.4.5\config.inc.php file into your MySQL database password.

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

Thus, I hope the above solutions help you to resolve the phpMyAdmin access denied showing error #1045.

----------------------------------
Regards,
Rex Maughan