Hi,
I know this is a common one (and it should be given the extremely bad design!)...after changing the mySQL root password from (blank) to something, I am no longer able to get into phpMyAdmin with it telling me that the root password is incorrect. I came across the various articles which advised to edit the phpmyadminX.Y.Z\config.inc.php. So I tried both of the below options editing the files in WordPad.
Option 1:
edit [x]:\wamp\apps\phpmyadminX.Y.Z\config.inc.php
Change
$cfg['Servers'][$i]['user'] = 'root' to your new admin Userid
$cfg['Servers'][$i]['password'] = '' add in your new admin users password between the single quotes.
Option 2:
Makes the browser ask for a valid Userid/password set when you run the phpMyAdmin link and does not need the new userid/password set to be stored in the config file.
edit [x]:\wamp\apps\phpmyadminX.Y.Z\config.inc.php
Change
$cfg['Servers'][$i]['user'] = 'root'; TO $cfg['Servers'][$i]['user'] = '';
leave the ['password'] entry as '';
$cfg['Servers'][$i]['AllowNoPassword'] = true; TO $cfg['Servers'][$i]['AllowNoPassword'] = false;
add this line to make exiting phpMyAdmin return to a clean url instead of giving an error message
$cfg['Servers'][$i]['LogoutURL'] = 'http://localhost/';
I kept on getting the same screen but then suddenly regardless of what is contained in the conf file, when I launch phpMyAdmin, I get the contents of the conf file displayed instead of a webpage! I even tried reverting back to the default one (I copied it earlier) but I get the same thing. All this despite numerous service restarts and server reboots. I get the same thing in Firefox and IE. See screenshot: [
s15.postimage.org]
Could anyone advise?
Thanks