I have had the EasyPHP WAMP running fine for the past month, but I just followed MySQL's advice to put a password on 'root' user and now when I try to access MySQL from PHPMyAdmin I get the message:
#1045 - Access denied for user 'root'@'localhost' (using password: NO). I have tried 2 suggested solutions involving editing the config.inc.php file in the phpmyadmin folder.
(1) following the instructions in EasyPHP Support FAQ #52:
Changing: $cfgServers['password'] = ''
To: $cfgServers['password'] = 'mynewpassword'
(2) following a suggestion posted here:
Changing: $cfg['Servers'][$i]['AllowNoPassword'] = false;
To: $cfg['Servers'][$i]['AllowNoPassword'] = false;
Which should make MySQL prompt for a password. I have also tried combining this with:
Changing: $cfg['Servers'][$i]['auth_type'] = 'config';
To: $cfg['Servers'][$i]['auth_type'] = 'http';
None of this has had any effect. The easyPHPadmin page continues to give the following parameters, (which surely it should update in acc with the config file) even when changes (1) or (2) have been made (and after restarting the computer):
MySQL parameters (default MySQL account)
- Host : 'localhost'
- Username : 'root'
- Password : '' (no password)
- Path to the database root (datadir) : C:\Program Files\EasyPHP-5.3.3\mysql\data\
Any help on this much appreciated! Regards, Nimbus