WampServer

OK,
I have wamp server running but I think the SQL connection is not working as my php pages indicate this.
I have tried connecting via 127.0.0.1 & localhost.
Anyone had this problem or have a solution ?

Windows Vista & latest wamp server

I created a database and new user in MySQL and then removed it.

I now have no access to phpMyAdmin and when I try I get this error:

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

My config.inc.php file:

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed

This is always what it has been.

I also am not able to cmd into MySQL. When I select MySQL Console it pops up a screen which is requesting a password, everything I tried closes the window with a beep.

I've tried everything I know with no success.
I am a newbie to WAMP.PHP/MYSQL

Please help as this is critical (to say the least)...

TIA,
WebGuy

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

Thank you for your reply...

I have read all your posts here before posting my request...and I've gone to your website and done what you request:

STEP 1
"1. For first place, use either MySQL consol (1a) through tray icon or phpMyAdmin (1b) through browser/localhost.

1a. Using MySQL consol: first time user just press Enter when ask for password, then type as belows, remember case is sensitive:
SET PASSWORD FOR root@localhost=PASSWORD('put_your_password_here'); "

When I access MySQL consol and hit enter (without password) the window closes (with a beep)

1b. Using phpMyAdmin: from your Browser/Localhost:
Open your desire browser
Goto: localhost/phpmyadmin/
Click on "Privileges" link
Click on "edit Privileges" link for ROOT user
Set-up your_new_password (change password)
Click go

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

I tried changing the PASSWORD in the config.inc.php file but nothing works?

When I access localhost/index.php it says: "MySQL not launched or bad phpmyadmin config"

MySQL is running.

If I re-install WAMP would that wipe out my existing databases?
OR does anyone have any other suggestions.

Thanks,
WebGuy



Edited 1 time(s). Last edit at 12/05/2007 10:14PM by WebGuy.

OK I managed to setup SQL with PHP myadmin that came with WAMP.
I imported a whole database into the sql server on the WAMP machine and I checked the tables and all was OK.
However I am not surenow that I set the SQL database is set up correctly as my php pages do not load, I just get a line saying the page cannot be displayed at this time.
How would I check to see if the database is set up correctly ?

Quote

I imported a whole database into the sql server on the WAMP machine and I checked the tables and all was OK

How did you restore them? How did you check it? Are all privileges associated w/ their assigned db?

Have fun,

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

Oh that is a good point, I imported the database but did I create a user ? I think you are right, I was thinking that the user for the database would be part of the data base so I think this is it, I'm so used to using sql with the sql manager GUI I forgot, so thanks, I'll try this...