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?
2 Answers
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;
4 Comments
Jeremy Thompson
Rejected Edit: i got the same error when i install xampp on my windwos7 system. solution i found is: in config.inc.php file i replaced the $cfg['Servers'][$i]['auth_type'] = 'config'; to $cfg['Servers'][$i]['auth_type'] = 'cookie'; then everything working fine... test your luck if have same issue...
Sagiruddin Mondal
I am having this problem on my production server... I am using filezilla, Can you please tell me where can I get this config.inc.php in that running server files ? any help will be appreciated. Thank you.
mighty_dev
In wamp , for those who are finding hard to get config.inc file ,it is present in \wamp\apps\phpmyadmin\ folder.
Black
Why is phpmyadmin not doing this for us??! (PS: On Linux Lampp the folder is in lampp/phpmyadmin/config.inc.php
Here are few steps that must be followed carefully
- First of all make sure that the WAMP server is running if it is not running, start the server.
- Enter the URL http://localhost/phpmyadmin/setup in address bar of your browser.
Create a folder named config inside C:\wamp\apps\phpmyadmin, the folder inside apps may have different name like phpmyadmin3.2.0.1
Return to your browser in phpmyadmin setup tab, and click New server.
Change the authentication type to ‘cookie’ and leave the username and password field empty but if you change the authentication type to ‘config’ enter the password for username root.
Click save
- Again click save in configuration file option.
- Now navigate to the config folder. Inside the folder there will be a file named config.inc.php. Copy the file and paste it out of the folder (if the file with same name is already there then override it) and finally delete the folder.
- Now you are done. Try to connect the mysql server again and this time you won’t get any error. --credits Bibek Subedi
[COLOR="rgb(255, 140, 0)"]in the file too?