Mysqld Crashes immediately on running on Windows 7...?

Question

I am trying to run MySql 5.1 on Windows 7 Home Premium 64 bit. I have downloaded the MSI installer from the MYSql website and installed it. The installation is successful, but the service does not start.

If I try to run MySql manually using the mysqld executable, it crashes immediately on running (error: mysqld.exe has stopped working).

Earlier mysql was running on the machine, but I had some problem with it (wasn't executing big queries) and installed it again which somehow broke the program. I had installed it to work as a service which started giving me this isse, and now it won't work even if I don't install it as a service.

I have tried removing the mysql folder and re-installing. Is there somewhere else where Mysql saves configuration info or other data?

Has anyone else found this problem and solved it?

How can I find out why the process is failing to run?

Answer 1

See the Debugging a MySQL Server in your MySQL reference manual.

• download the noinstall (zip archive) version of MySQL corresponding exactly to the version that is already installed on your system
• extract the .pdb symbols files to your existing MySQL installation's bin directory
• start Dr. Watson
• start mysqld-debug in standalone mode
• capture the list of all moduled (i.e. loaded DLLs) with their full path from DrWatson
• capture the stack trace from DrWatson
• examine the MySQL log files (including mysqld.trace) to see what went on immediately prior to the crash

Cheers, V.