Everytime I start the mysql service it stays on for about 5 seconds and then it turns off. I can't seem to keep on. This happened after I upgraded from 1.6.4 to 1.6.6. Please Help!
make sure there are no other SQL servers apps running on the computer, and make sure nothing else is using the same port as the SQL server in WAMP. The same thing happened to me and I had SQLite installed (and they used the same port). Once I uninstalled SQLite, SQL in WAMP stayed on.
Correct me if I'm wrong but it might be a conflict while upgrade because you think it's just from 1.6.4 to 1.6.6 so it's not really the problem but it actually a big jump from mysql 5.0.22 to 5.0.27 and especially from php 5.1.4 to 5.2.0; so it might be bad to say that you should backup your data to somewhere safe then uninstall and reinstall wamp. Hope it solve the problem