phpmyadmin error : Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection
A few email enter my mailbox regard my last post about setting mysql root password in wampserver.
The exact message is :
Welcome to phpMyAdmin
Error
MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I try to explain how to fix this problem.
By default wampserver will install in folder C and I’ll use that information as base of tutorial.
Open Configuration file of phpmyadmin
Go to folder :
C:\wamp\apps
you’ll see folder ‘phpmyadmin3.2.0.1‘ , value of 3.2.0.1 will be vary depend on your wampserver version.
double click that folder and find file with name “config.inc.php”
Change the file
Double click ‘config.inc.php’.
Original content of the file is :
<?php /* Servers configuration */ $i = 0; /* Server: localhost [1] */ $i++; $cfg['Servers'][$i]['verbose'] = 'localhost'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $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'] = 'root'; $cfg['Servers'][$i]['password'] = ''; $cfg['Servers'][$i]['AllowNoPassword'] = true; /* End of servers configuration */ $cfg['DefaultLang'] = 'en-utf-8'; $cfg['ServerDefault'] = 1; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?>
Change $cfg['Servers'][$i]['password'] = ”; to new value
$cfg['Servers'][$i]['password'] = ‘yourmysqlrootpassword’;
save the file and try access phpmyadmin.
I hope it help
Stay Health!
Related Reading:
Using DrupalWith the recipes in this book, you can take full advantage of the vast collection of community-contributed modules that make the Drupal web framewo... Read More >
Drupal For DummiesLearn to set up, manage, and administer a Drupal Web site
Drupal offers unparalleled flexibility for content-managed Web sites, but most ... Read More >
Pro Drupal Development, Second EditionWidely praised for its in–depth coverage of Drupal internals, bestselling Pro Drupal Development has been completely updated for Drupal 6 in thi... Read More >
Front End Drupal: Designing, Theming, Scripting“For Drupal to succeed, we need books like this.”
–Dries Buytaert, Drupal founder and project... Read More >
Cracking Drupal: A Drop in the BucketThe first book to reveal the vulnerabilities and security issues that exist in the sites that have been built with Drupal?and how to prevent them from... Read More >
Search Terms :
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.



