Pages: Previous12
Current Page: 2 of 2
Re: #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Posted by: yfastud (Moderator)
Date: January 06, 2008 09:34PM

Just let you know in case you're still interested in setup password

I've just finish updating Setup WAMP and Setup Password on my websites.

Hope that I would finish Setup MySQL Database by tomorrow

Compare to MySQL sites or results from google, my guide is much easier for new wamp users because it shows step by step w/ illustrated images, especially they are created for this particular wamp package

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Posted by: grittson (---.nott.cable.ntl.com)
Date: January 29, 2008 12:07PM

This thread is relevant to my problem. I set up wamp fine and had it all working well. I changed the password for access to localhost using phpmyadmin, logged off and now phpmyadmin will not connect to mysql.
The solution that worked for others is difficult for me because I have three files called config.inc.php in \wamp\scripts, in wamp\apps\phpmyadmin2.10.1 and a third in wampapps\sqlitemanager1.2.o\include.
Which file should I be changing?
In addition I cant find any lines of code that match the code that you describe below.
Where am I going wrong?
-----------------------
Actually, you need to edit the third line in config.inc.php

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed

To become:

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'same_password_put_in_phpmyadmin'; // MySQL password (only needed

Then save the file and restart wamp to take effect
--------------------------------------
Thanks
Greg

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Posted by: yfastud (Moderator)
Date: January 29, 2008 01:09PM

In my guide Setup Password on my personal websites, it stated very clearly the location for the file

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides



Edited 2 time(s). Last edit at 01/29/2008 01:13PM by yfastud.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Posted by: nulty (---.b-ras2.prp.dublin.eircom.net)
Date: March 26, 2010 03:07AM

Good on ya Pam!

Clearing the web history, Cache and all from my browser got my phpMyAdmin working.

@ yfastud

Your right about this being a public forum and giving as much info as possible winking smiley

Don't know what that lady's problem was but she seemed very angry LOL

Thanks again Pam for sharing your discovery!

Options: ReplyQuote
Pages: Previous12
Current Page: 2 of 2


Sorry, only registered users may post in this forum.