Problem with MySQL service
Posted 08 September 2003 - 04:27 PM
Loaded MySQL 4.0
Loaded MyODBC 2.5
Setup the DSN to point to the database I\'m going to create. Opened up WinMySQLAdmin 1.4 to establish a connection. Used command prompt to create database, and everything seemed to work just fine.
However, if I close WinMySQLAdmin or reboot my machine. I can\'t get the service to start up again. WinMySQLAdmin won\'t connect, and if I try to manually restart the service, I get \"error 1067: The process terminated unexpectedly.\"
The only way I\'ve found to get it working again is to uninstall everything, redownload MySQL and MyODBC, reinstall, and sometimes this works. That\'s obviously really crappy and not an acceptable solution.
Does anybody have any ideas?
Posted 09 September 2003 - 05:38 AM
Also you can make the service start automatically when the system is started and also there are settings that can make it try more than once if there are any issues in startrting.
Posted 09 September 2003 - 05:36 PM
Posted 10 September 2003 - 04:26 AM
Mysql is just a service and as I said eralier make mysql run \"AUTOMATIC\".
Posted 10 September 2003 - 01:07 PM
It\'s kinda weird though. I setup MySQL on another Win2k machine, and it runs perfectly. Everytime you reboot, the service starts automatically. Everything is great.
But on my machine, and a WinXP machine I also set it up on, I can\'t get the service to run automatically. Like I said before, if you reboot, or just close the WinMySQLAdmin instead of hiding it, you can never get the service started again... Manually or automatically. I know there\'s got to be something that\'s set incorrectly that I just have to find. I\'m going to try comparing the my.ini on the working computer with that on the non-working computers. Maybe I can see something there and just manually edit the my.ini on the non-working computers. Worth a shot I guess.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users