MySQL 4.1 Error On Windows 2000 Pro

LeetViet

Platinum Member
Mar 6, 2003
2,411
0
76
I previously had MySQL 4.0.x installed, I uninstalled that and deleted the directory in Program Files.

I installed MySQL 4.1.x and ran the MySQL Server Instance Configuration and it worked fine -- until I rebooted. It gives me the "Could not start the server MySQL. Error:0", but there was no service after rebooting (and yes, I did check "Launch the MySQL Server automatically" under "Install As Windows Service")

I've checked with Task Manager, Administration Tools->Services, and another 3rd party program and could not find any MySQL services.

Now, if I run mysqld.exe it opens and closes and the service shows up but I can't connect to the server (localhost).

Any suggestions on what other steps to try?
 

stndn

Golden Member
Mar 10, 2001
1,886
0
0
MySQL Server Instance Configuration Wizard requires previous MySQL service to be removed before installing a new one.

Try running it once again (after you verify that there is no MySQL service in the list of windows service) and see if it works. Otherwise, try reinstalling it from the beginning.

I had to reinstall a few times before i found out what the problem was >(
 

LeetViet

Platinum Member
Mar 6, 2003
2,411
0
76
I figure I'd have to uninstall. :(

I uninstalled, deleted the MySQL directory in Program Files, restarted, reinstalled and ran the service as MySQL41 just incase. It works now. :)

Edit: After restarting there are no services and I try to run MySQL again, it does not work. :mad:
 

stndn

Golden Member
Mar 10, 2001
1,886
0
0
hmmm... i forgot how i did that.
Probably
1. Stop mySQL service
2. Uninstall
3. Delete my.ini from your windows directory (i think this was what caused us the headache)
3. Restart computer and check MySQL service is not there, and not running
4. Install, but don't run the configuration thing.
5. Restart again
6. Run the configuration


You could probably do away with stopping and removing mySql service, delete my.ini, and redo the auto configuration. Otherwise, the above steps might be necessary


More info can also be found on mysql support forum if the above didn't work
 

LeetViet

Platinum Member
Mar 6, 2003
2,411
0
76
I reformatted, installed MySQL 4.1.12, restarted, ran the server instance config -- it worked, restarted, it didn't work and I couldn't find the service/process in Task Manager. I did mysqld --install MySQL41 --defaults-file="C:\Program Files\MySQL\MySQL Server 4.1\my.ini" in C:\Program Files\MySQL\MySQL Server 4.1\bin at the command prompt, checked with Task Manager and the process isn't there. I checked again with Administrative Tools -> Services and it was there, I started it but I still couldn't connect to localhost.

I'm pulling my hair out on this one. :mad:
 

LeetViet

Platinum Member
Mar 6, 2003
2,411
0
76
Uninstalled MySQL 4.1.12 and installed MySQL 4.0.25.

Same symptoms. Works but after restart it no longer works. :(
Tried Googling some more and people with similar problems either haven't resolved their problems or their method haven't worked for me.

Anymore suggestions?