which MySQL and PHP version should I use with WAMP


I recently reformatted my computer and in the process I removed my WAMP server and reinstalled it again.

I reinstalled it with WAMP 2.0, PHP 5.2.9-2, and MySql 5.1.33.

I devloped a website that worked fine on the WAMP server before and now has a few minor hiccups. (unfortunately I cannot remember the versions I had before).

The site interacts with the database on the new set up just not all the time. Some times it will insert, other times it will not. The time it will not work  is in a foreach loop, with auto commit set to false, and then committing all data to the database in one go.

Am I using the wrong version of WAMP, PHP, or MySQL?

P.S. I tried to download and use MySQL 5.0.51b and I get the message "#1045 - Access denied for user 'root'@'localhost' (using password: YES) "

Any help would be much appreciated, thanks.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sometimes the user privileges are screwed when you switch from mysql 4 to mysql 5... there is something about the old_password function that can fix this but i can't remember what, and this may or may not help you with your problem. but its somewhere to start looking.
iDeejAuthor Commented:
I'm new to setting up a new PHP MySQL server system, so rather than risk messing things up even further I ended up starting from scratch and now have it up and running. I am still haveing an odd error that I was not happening before this install.

The problem is here: http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/Q_24435237.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.