Hello everyone. I am new here
I downloaded and installed the wamp 2.0 package today after using apache, php and mysql separately. Apache and PHP in wamp seem to work perfectly well, but mySql appears to be broken and I'm not sure if its a bug on my end. Any help with this would be highly appreciated.
So. After I installed wamp, I went into ...\Wamp\bin\mysql\mysql5.0.45\bin and ran MySQLInstanceConfig.exe first thing to configure mysql. Everything is fine until the "Ready to execute..." phase. Once I click the Execute button, it fails at the 2nd step (Write configuration file) saying "The template configuration file cannot be found at (path)\my-template.cnf.
I googled for a while then I found that my-template.cnf should actually be my.ini. So I took a copy of my.ini, renamed it to my-template.cnf and put it in the bin folder. The setup now finally sees it and gets past that problem, but there is another separate problem now that it cannot get past... the one I actually need to know about;
After successfully completing step 1 and 2, at step 3 (Start service) it fails with the error "Could not start the service MySQL.Error:0" After looking for what may be causing this for a while, I finally found out the cause; I went to Administrative Tools, Services, and went to the service MySQL in that list (generated by the InstanceConfig tool), and checked its properties. For Path to exacutable: I found this in the line there: "...Wamp\bin\mysql\mysql5.0.45\bin\bin\mysqld-nt" --defaults-file=...".
The problem is caused at the "\bin\bin\" part. There should only be one bin, "\bin\". "...\mysql5.0.45\bin\mysqld-nt..." would be the correct path. Posted in this screenshot here [
img223.imageshack.us] . So this error is caused by that file being generated like that. And I cannot manually change that path either, because if I do the InstanceConfig then tells me there is already a MySQL service running and I must remove that one before running it. Its InstanceConfig that must generate it correctly.
I have tried everything. I reinstalled wamp, removed everything from the old mysql from the registry and folder, installed in different locations, but nothing. Can someone please tell me whats wrong with it and what I must do to run the instanceconfig tool and have it execute all steps correctly? Thanks lots!