MySql - Cannot connect: invalid settings.

[jovemac]

Hi!

I am new to php. For learning purposes i installed xampp. Wheni opened phpmyadmin, it said that root is left open without a password. I do changed the password for root@localhost and root@127.0.0.1. Thought both are same and gave the same password for both. Now i am getting the error message as below.

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.

Please advise.

Regards - Jo

[Wiedmann]

You must also adjust the password in "config.inc.php".

[agiles]

Alright I found a fix.

because of xampp server had the following settings. go to this directory C:\xampp\phpMyAdmin\config.inc.php

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; // which is default setting in xampp server

and now u have to change this default null password to your password
$cfg['Servers'][$i]['password'] = 'your password';//type your password

[xfsgpr]

Alright I found a fix.

because of xampp server had the following settings. go to this directory C:\xampp\phpMyAdmin\config.inc.php

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; // which is default setting in xampp server

and now u have to change this default null password to your password
$cfg['Servers'][$i]['password'] = 'your password';//type your password

My configuration file has the following entries:

$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

No problems here logging in to MySql server. It is an automatic process.