Access denied for user 'root'@'localhost' with PHPMyAdmin

php mysql phpmyadmin wampserver
Sam picture Sam · Jul 14, 2012 · Viewed 150.8k times · Source

When I set the root password in PHPMyAdmin, I get this error:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I can't open the PHPMyAdmin panel. What am I doing wrong?

Answer

Sathishkumar picture Sathishkumar · Jul 14, 2012

Edit your phpmyadmin config.inc.php file and if you have Password, insert that in front of Password in following code:

$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'] = '**your-root-username**';
$cfg['Servers'][$i]['password'] = '**root-password**';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Related questions

WAMP/MySQL errors not in correct language

I've re-installed WAMP multiple times, searched literally hundreds of pages, and its not fixed this issue: I've looked inside the phpmyadmin config files, set: $cfg['Lang'] = 'en-utf-8'; Uninstalled multiple times (as mentioned) and seemed to have no luck what …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More