WampServer

I have recently installed Wampserver 2, having unistalled the Wamp5. I was able to make contact with localhost MySQL via phpMyadmin, but was warned of the security hole. So I password protected the MySQL and then added the password to the config.inc.php. I have now been denied access with the error message
"#1045 - Access denied for user 'root'@'localhost' (using password: NO) "
I have checked the accuracy of the password by logging directly into MySQL Command line.
I have the entries "config", "root" and then the password on lines 71-73. Is there something else I should be doing?

I would advise you to delete the session's temporary files that are in \wamp\tmp\ directory.
It has solved me when i couldn't access phpmyadmin.

Delete all files in it except \wamp\tmp\session_dir which file is part of wamp installation..

try that and tell us if it worked. (or just move them into a bakup folder outside the \tmp\ dir)

---------------------------------------------
XP SP3 - pIV - 3.2Ghz - 1.5Go de ram - Wamp 2.0

Check my websites for proper password setup

Have fun,

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

I've tried your idea of removing the files, rep_pit, but to no avail.
I'll have to do the work and read up on Mr yfastud's instructions.
Thanks to you both.

yfastud, as I said, thanks for your post, however I'm having a problem with your website www.jlbn.net in that your links to "Guides" (gives me an error message) and "Contact" (does nothing) don't work.
Is there a url you could give me to get me to the relevant page of your site, please.
Muchos.

It's on the main page; scroll down to the password setup section

Have fun,

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

Thanks. Having followed those instructions I'm still having the same problem.
I am guilty of not cleaning out the registry when I uninstalled WAMP5, so perhaps that is giving me problems.
I am contemplating uninstalling again, clearing the registry this time, and re-installing. Good idea?
However, I will need a bit of guidance about what to do in the registry department, as it's an area that I have only ventured into very biefly in the past. Can you point me towards a useful article/intructions?
Thanks,
Steve

It's not really scary as you think since you didn't actually write any code to modify anything, so after uninstall wamp, delete wamp folder, and empty Recycle Bin, then open registry as follows:

In XP: Start, Run, regedit, OK

In Vista: Start, search "regedit", right click and select "Run as Administrator"

In the main window of Registry Editor, go to Edit / Find (or Ctrl + F), then search and delete wampapache and wampmysql

Restart computer then reinstall wamp

If you're still not sure, before search and delete, just make a backup by go to File / Export

Have fun,

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



Edited 1 time(s). Last edit at 12/05/2007 06:17AM by yfastud.

I'm having a similar problem. I changed the name and password of the root account in mysql with no problems. I can access the databases using the command-line utility with no problem. I changed the variables in config.inc.php to reflect the new values:

$cfg['Servers'][$i]['controluser'] = 'username';
$cfg['Servers'][$i]['controlpass'] = 'password';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'username';
$cfg['Servers'][$i]['password'] = 'password';

I tried deleting the tmp session files. I tried restarting all services. Yet I still get the error:
Error
MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

It's like phpmyadmin isn't reading the changed config file at all.

Added: I had no previous version of WAMP installed.



Edited 1 time(s). Last edit at 12/07/2007 11:53PM by moborouter.

You did it wrong, so check my websites for proper password setup

Have fun,

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

ok my line states MySQL user
$cfg['Servers'][$i]['password'] = 'I PUT MY PASSWORD HERE';
still getting the same error
by the way that folder( /wamp/phpmyadmin) does not exist

########
#UPDATE#
########
I was able to get in now but only after trying something that should not have worked.
On the no access page to the right there is a database select dropdown menu. I simply selecte one it took me to it and then I just clicked the home button. Sorry I doubted your PHP/mySQL/Apache master, but from the looks of it your were wrong. But I have to do this every time i go to phpmyadmin.



Edited 4 time(s). Last edit at 12/08/2007 04:20AM by ratnight.

That guide has been there for a while and was for the older wamp version; however, still have a lot of people using it successful, and here are some:

[forum.wampserver.com]
[forum.wampserver.com]

Have fun,

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

Thanks, yfastud, with your help I have now managed to re-install Wampserver2 and establish the password security.

By the way, 2 posts ago ratnight wrote
>"by the way that folder( /wamp/phpmyadmin) does not exist "

I have found that the address for the config.inc.php in the current WampServer2 is now:

/wamp/apps/phpmyadmin2.10.1/

Yep, you're right, new wamp2 has new location for almost all files, but I didn't have time to update all the guide just yet

Have fun,

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