WampServer

i do need ur help anyone..when i click phpmyadmin it says cud not connect to mysql..password incorrect..what shall i do?

I cannot open the phpmyAdmin because the error cannot be removed

MySQL said:

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

I have even tried restoring to an earlier date(the day before) and the screen is the same?

Have you recently set a password for the MySQL root user? if so you'll have to tell phpMyAdmin that within its configuration file C:\Wamp\apps\phpmyadmin\config.inc.php

Locate the following line
$cfg['Servers'][$i]['password'] = '';

Enter the password for the root user within the quotes. Save and reload phpmyadmin.

it's not recommended to hard code password in config file, so follow this
download resetmysql here
[downloads.jlbn.net]

to setup password, follow this
[blog.jlbn.net]

Have fun,

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

try the tutorial at

[Link is removed by moderrator]

or

[Link is removed by moderrator]

or

[Link is removed by moderrator]

Fitcom - Technology and SEO with a side of awesome

Installing and Configuring a WAMP Server in Windows 7 & 8



Edited 1 time(s). Last edit at 02/09/2009 10:55PM by yfastud.

I too get a #1045 - Access denied for user 'root'@'localhost' (using password: NO) message when I click phpmyadmin link on home page.

This is a fresh installation, WinXP.sp2

C:\Wamp\apps\phpmyadmin\config.inc.php indicates no password required:

$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

I found the error. The solution is here:

[forum.wampserver.com]

fantoo Wrote:
-------------------------------------------------------
> I found the error. The solution is here:
>
> [forum.wampserver.com]

Sorry, wrong problem. =P

Thanks for your attempts to help me.

I made the suggested change ("Allow all" but still get #1045 - Access denied for user 'root'@'localhost' (using password: NO)

I rebooted; uninstalled wamp and deleted any remaining files and folders. I then redownloaded wamp2.0 and installed again, using the defaults and requesting Firefox as the default browser.

I should have mentioned this before but I get no response when I launch wampmanager.exe. I see a brief hourglass icon, then nothing. Task Manager reports nothing running. Is this normal?

Thanks,
John

what color of your wamp tray icon?

Have fun,

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

"what color of your wamp tray icon?"

Blue

he he... he he... ;-)
you're funny, buddy
it's either red, yellow or white and only white is good, others means your wamp has problem

Have fun,

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

As I thought.

I'm going to install Apache, MySQL and PHP individually from their respective web sites.

So thanks anyway!

John

if something blocks your wamp, it would still block even installing stand alone, and at that time it's more difficult to troubleshoot because of registries conflict, so you'd better figure out now what causes the problem ;-)

Have fun,

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

Check your services.msc and make sure that the wamp services are running.

Thanks to all who offered help!

I was hoping to save some time by developing PHP/MySQL code on my local machine rather than up and down loading from my site as I do now.

Having spent more time than I would have saved, I'll just return to the old way.

Thanks again,
John