phpmyadmin error : Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection

Posted at November 12, 2009

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.

phpmyadmin config file1 phpmyadmin error : Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection

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”

phpmyadmin config file phpmyadmin error : Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection

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.

phpmyadmin config file2 phpmyadmin error : Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection

I hope it help :-)

Stay Health!

Related Reading:

Using DrupalUsing Drupal

With 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 DummiesDrupal For Dummies

Learn 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 EditionPro Drupal Development, Second Edition

Widely 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, ScriptingFront 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 BucketCracking 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 >

Thanks for reading, if you think this post help you please consider to buy me a beer

Search Terms :

  • phpmyadmin allownopassword
  • allownopassword phpmyadmin
  • 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 serv
  • cannot connect: invalid settings
  • You should check the host username and password in your configuration
  • phpmyadmin tried to connect to the mysql server and the server rejected the connection
  • mysql said: documentation cannot connect: invalid settings
  • phpMyAdmin Cannot connect: invalid settings
  • allownopassword
  • phpmyadmin-error: cannot open themes folder: /themes
  • mysql said: cannot connect: invalid settings
  • wamp cannot connect: invalid settings
  • mysql allownopassword
  • ubuntu phpmyadmin allownopassword
  • 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 t
  • cannot connect invalid settings phpmyadmin
  • Error MySQL said: Documentation Cannot connect: invalid settings
  • phpadmin AllowNoPassword
  • allownopassword mysql
  • xampp 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 MySQ

    • Share/Bookmark
    Tips

    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.

    Comments are closed.