hello,
xampp: 1.7.7
os: windows 7
xampp control panel version: 3.0.2
i am also experiencing the same issue.
it was my first time installing xampp, so as it was a new process i cannot completely remember my steps, but i think they were:
- install xampp
- go to localhost/xampp and click 'security'
- notice that some things stated 'unsecure'
- click on the link below this called http://localhost/security/xamppsecurity.php
- change the 'MYSQL SECTION: "ROOT" PASSWORD'
- change the 'XAMPP DIRECTORY PROTECTION (.htaccess)'
at some point i have also gone into xampp/phpMyAdmin/config.inc.php and chaged this line:
- Code: Select all
$cfg['blowfish_secret'] = 'anewphrasehere'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */
i was getting the error message that was in the original post when going to localhost/xampp > clicking on phpMyAdmin:
"MySQL said:
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".
but after following suggestions in last post and changing:
- Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config';
to:
- Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'cookie';
in xampp/phpMyAdmin/config.inc.php, when i click on phpMyAdmin i am taken to a phpMyAdmin login page, but entering the username/password that are in xampp/phpMyAdmin/config.inc.php gives me this error:
'Cannot log in to the MySQL server'
please let me know if i need to provide any more information.
thank you!
edit: i'm also noticing that when changing MySQL password in http://localhost/security/index.php and selecting either 'http' or 'cookie', this choice is not being changed in the phpMyAdmin/config.inc.php file, ie if you type the auth type as 'http' into that file, then change password and select auth type as 'cookie' in the web interface, it stays defined as 'http' in the phpMyAdmin/config.inc.php file.
edit 2: also tried deleting root password by running resetroot.bat as suggested in the link below and i couldn't access phpMyAdmin.
http://community.apachefriends.org/f/viewtopic.php?f=16&t=50048&sid=09ec1ac8b1aa12e4f2385b40e4beda27#p192991
edit 3: also tried suggestions in this link but unfortunately they had no effect:
http://community.apachefriends.org/f/viewtopic.php?f=16&t=50063&sid=09ec1ac8b1aa12e4f2385b40e4beda27#p193021