phpMyAdmin: can't login after password configuration
Posted by: Passy (---.dialin.heagmedianet.de)
Date: October 20, 2006 05:03PM

Hi!

I just changed my password on phpMyAdmin.
But I didn't set the configuration below on "using password: YES"

Now my problem is that I can't reach phpMyAdmin any more.
Instead I receive this:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

How can I reach the configuration table and change "using password:"
to "YES"?

Greetings
Daniel

Options: ReplyQuote
Re: phpMyAdmin: can't login after password configuration
Posted by: yfastud (---.mia.bellsouth.net)
Date: October 20, 2006 06:44PM

How did you change it? Check my post here:

[forum.wampserver.com]

Hope this help

Options: ReplyQuote
Re: phpMyAdmin: can't login after password configuration
Posted by: hockey97 (---.col.wideopenwest.com)
Date: October 23, 2006 04:25AM

Hi It happened to me too I followed that link given from the guy above, and I added the new password and lock myselfout.

what I did and what I think is best is to uninstall the wamp server and install it back one.

this is the only way I found that was the only think I could think off that would help, I look at other way's around this but seem to not find anything.

Options: ReplyQuote
Re: phpMyAdmin: can't login after password configuration
Posted by: yfastud (---.cable.mindspring.com)
Date: October 23, 2006 05:16AM

Hey guys, did you read the post CAREFULLY?

You need to setup password in TWO PLACES that are phpmyadmin through browser AND file config.inc.php in folder /wamp/phpmyadmin

So before uninstall and reinstall, try it first.

Good luck.

Options: ReplyQuote
Re: phpMyAdmin: can't login after password configuration
Posted by: CyberSpatium (71.237.217.---)
Date: October 23, 2006 04:52PM

make sure if you changed the password for your root user, that you edit your phpmyadmin conf file and add the new password

open C:\wamp\phpmyadmin\config.inc.php and find:
$cfg['Servers'][$i]['password'] = '';

change it to
$cfg['Servers'][$i]['password'] = '_Your_New_tongue sticking out smileyassword_Here_';

Options: ReplyQuote
Re: phpMyAdmin: can't login after password configuration
Posted by: Passy (---.dialin.heagmedianet.de)
Date: October 25, 2006 06:55PM

Hi!

You really helped me out with ease! @yfastud & @CyberSpatium
phpMy Admin was running after my first try to fix it with the instructions
of CyberSpatium.

Thanx a lot, Passy

Options: ReplyQuote


Sorry, only registered users may post in this forum.