#1045 Cannot log in to the MySQL server message
total newbie here. I need to be able to use the WAMP Server 2.4, phpMyAdmin. I am getting the error message: #1045 Cannot log in to the MySQL server.
I had gone in through the MySQL console (taking a class). I followed the directions to successfully change the pw and now cannot get into the WAMP Server . . .
I have gone in and tried, successfully to change the pw. Still no luck.
At the "http://localhost/phpmyadmin/" screen, I have my user name as a default and then the hidden pw. I tried the pw I made and get the #1045 message.
I read in a couple forums that I needed to make changes to:
but I don't have those lines as options which I can edit. All I have is this:
$cfg['Servers'][$i]['user'] = 'root'; //mysql username here
$cfg['Servers'][$i]['password'] = 'password'; //mysql password here
Should I add the above lines?
/* vim: set expandtab sw=4 ts=4 sts=4: */
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use setup/
* All directives are explained in documentation in the doc/ folder
* or at <http://docs.phpmyadmin.net/>.
* @package PhpMyAdmin
* This is needed for cookie based authentication to encrypt password in
$cfg['blowfish_secret'] = 'a8b7c6d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
* Servers configuration
$i = 0;
* First server
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
* phpMyAdmin configuration storage settings.
Or is there some other solution?
I am so lost here -- no help yet from the instructor.
Thank you for all help.