Friday, August 20, 2010

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

source :
http://www.hostingformula.net/phpmyadmin-error-cannot-connect-invalid-settings-phpmyadmin-tried-to-connect-to-the-mysql-server-and-the-server-rejected-the-connection/


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


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 :
view sourceprint?
01.02.
03./* Servers configuration */
04.$i = 0;
05.
06./* Server: localhost [1] */
07.$i++;
08.$cfg['Servers'][$i]['verbose'] = 'localhost';
09.$cfg['Servers'][$i]['host'] = 'localhost';
10.$cfg['Servers'][$i]['port'] = '';
11.$cfg['Servers'][$i]['socket'] = '';
12.$cfg['Servers'][$i]['connect_type'] = 'tcp';
13.$cfg['Servers'][$i]['extension'] = 'mysqli';
14.$cfg['Servers'][$i]['auth_type'] = 'config';
15.$cfg['Servers'][$i]['user'] = 'root';
16.$cfg['Servers'][$i]['password'] = '';
17.$cfg['Servers'][$i]['AllowNoPassword'] = true;
18.
19./* End of servers configuration */
20.
21.$cfg['DefaultLang'] = 'en-utf-8';
22.$cfg['ServerDefault'] = 1;
23.$cfg['UploadDir'] = '';
24.$cfg['SaveDir'] = '';
25.
26.?>

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!


source :
http://www.hostingformula.net/phpmyadmin-error-cannot-connect-invalid-settings-phpmyadmin-tried-to-connect-to-the-mysql-server-and-the-server-rejected-the-connection/