WampServer

When I open PHPmyadmin I get an error that saysS

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

I am using a password for MYSQL and I know its correct because I have logged into the MYSQL console successfully.

Any suggestions would be great.

Thanks
Camster

You only set password for mysql, and you need to set it for phphmyadmin too. Check Setup Password guide on my personal website

Have fun,

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

find the file config.inc.php. It will be in the directory that you have your phpmyadmin installed in.

find the following line:

$cfg['Servers'][$i]['password'] = '' <<<<in the '' put your root password

on my set up it was line 73. set your password, then save the file.

then reload the phpmyadmin page and set all of you passwords in the privileges pages. you may have to reload the privilege page again as well.

Hope that helps.

I also get this message (prob due to deleting the root account after creating my own account).

I've tried looking EVERYWHERE on my pc for "config.inc.php" as stated above but can't find it anywhere.

I thought I could delete and re-install wamp server but that hasn't helped.

Could someone maybe point us in the direction of an idiots step by step guide please, I can't find any solutions anywhere else.

After uninstall wamp, you have to delete wamp folder and wamp registries which are wampapache and wampmysql before reinstalling wamp

Have fun,

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

look here:

C:\wamp\apps\phpmyadmin2.11.5

this assumes that you installed on the C: drive. if not change the letter to the correct drive letter.

--------------------------------------------------------
[tenminutesports.com] --- Nothing but sports headlines. No java, ajax, scripting, idiotic videos shoved down your throat, and no bloated graphics. JUST SPORTS HEADLINES! Tell your friends

Disable "Hide known extension..." in windows property to see your real extension; if not, you only see config.inc instead

Have fun,

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

camster Wrote:
-------------------------------------------------------
> When I open PHPmyadmin I get an error that saysS
>
> "MySQL said:
> #1045 - Access denied for user 'root'@'localhost'
> (using password:NO)"
>
> I am using a password for MYSQL and I know its
> correct because I have logged into the MYSQL
> console successfully.

Me too have this problem, and l am like you have access into the MYSQL console

I type this into console and recived full access:

GRANT USAGE ON *.* TO 'root'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'

or (if this don't works)

GRANT USAGE ON *.* TO ''@'localhost'
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost'

I'll hope, i help you =)