easyPhp phpMyAdmin access denied
I installed EasyPhp (version 5.3.9) on my windows 7 laptop and try to use the included phpMyAdmin module (selected from the easyPhp admin home page), but I am unable to log in - I get the following error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I did not change any file at all - so it should just use user=root and no password, I assume.
I checked other threads in SO but could not find any applicable solution. I also tried uninstalling easyPhp completely and reinstalling it, but same problem, even when clearing all browser cache as suggested in one of the threads.
What to do next? How can I go use the MySQL module in EasyPhp when I can't even go to the admin tool?
Answer
By default phpMyAdmin won't let you login without a password.
You will need to open config.inc.php in the phpMyAdmin directory, and make sure it is set as follows;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Note that 'AllowNoPassword' needs to be set to true.