Main Topics
Browse All TopicsI am a total newbie to MySQL. I'm in a position where I need to grasp MySQL and FAST!!!!
I have been really struggling. I was first getting the Error 2003 but after following the advice in one of the Experts Exchange forums it dissappeared.....only to be replaced by :
The MySQL service could not be started.
A system error has ocurred.
System Error 1067 has ocurred.
The process was terminated unexpectedly.
Please could somebody help me. I'm desperate!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
OK, I've tried the my.cnf changes and nothing seems to work. When Itry to start the service I get the following:
c:\mysql\bin> net start mysql
System error 2 has occurred
The system cannot find the file specified
Should I try and uninstall and start again? If so could you tell me how to uninstall MySQL because every time try it won't let me do it (even though I have dministrator rights on my machine.
Things are way beyond desperate now...
yes it would be better to reinstall mysql :
- kill the mysqld-nt.exe process with the task manager if it exists.
- delete the directory c:\mysql and all subdirectories
- delete c:\windows\my.ini
- reinstall mysql, preferably stable version (4.0.20)
- run c:\mysql\bin\winmysqladmin
- you should have an icon in the system tray, right click, Winnt / Install the service and net start mysql
- add c:\mysql\bin to your path
- try to log to mysql using : mysql -u root
This is a windows installation. The configuration file is in /windows or /winnt and the name is my.ini. Rename my.in and start mysql using winmysqladmin. If you want to reinstall I recommend using the zip to install mysql, not the exe with installer. There is a new version mysql 4.0.20.d for windows.
Hi. You should check the error messages Mysql stored in it's .err file. This file is either \mysql\data\mysql.err or \mysql\data\name.err (where "name" is your machine's name).
I once had this problem and it was a wrong size in innodb logs. I just deleted the logs and mysql started to work again (I could do that 'cos I didn't care for the data...)
good luck,
krahd.
>System Error 1067 has ocurred.
>The process was terminated unexpectedly.
I had the same problem in oracle database. I explored internet much and finaly I found reson.
In my case the problem was in different names my computer - when after I installed oracle database I change name of my computer. When re-establish old name the service started without errors :)
There are dwo links - mabye will help you...
http://www.orafaq.com/foru
http://www.4d.fr/documenta
I solved this problem!
I had the problem with Oracle.
It failed to start the 2nd service OracleServiceXE
because the path was wrong. I manually fixed it. (using knowledge from the Oracle uninstall manually instructions)
HKEY_LOCAL_MACHINE\SYSTEM\
Go there
Ensure image path is
C:\oraclexe\app\oracle\pro
probably it will be wrong.
do the same for all the services under
services.msc
start menu-->run-->services.msc -->anything that starts with Oracle and doesnt start.
Have the same problem here and solve it.
Try :
netstat -nab
If you see a line like this :
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
[mysqld-nt.exe]
That means the mysqld-nt.exe already in listening state on port 3306. So from your Task Manager try to find the program and kill itfirst. Then restart the service. It looks like the program executed not as service after I install it.
Business Accounts
Answer for Membership
by: ldbkuttyPosted on 2004-07-01 at 14:41:58ID: 11452016
From MySQL manual:
A system error has ocurred.
System Error 1067 has ocurred.
The process was terminated unexpectedly.
These errors mean that your option file (by default `C:\my.cnf') contains an option that cannot be recognized by MySQL. You can verify that this is the case by trying to restart MySQL with the option file renamed to prevent the server from using it. (For example, rename `C:\my.cnf' to `C:\my_cnf.old'.) Once you have verified it, you need to identify which option is the culprit. Create a new `my.cnf' file and move parts of the old file to it (restarting the server after you move each part) until you determine which option causes server startup to fail.