KevPerkins
asked on
System error 1067 - What does this mean?
I 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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://forums.devside.net/viewtopic.php?t=250&postdays=0&postorder=asc&start=15&sid=bf7ed52ece2cf766a582933f2a6fa26b
ASKER
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...
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 .exe it will ask you a user and a password. enter whatever you want it will not be used
- 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
- 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.
ASKER
thanks, i'll give it try and get back to you.
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.
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/forum/t/43502/0/
http://www.4d.fr/documentation/4DDoc67/CMU/CMU11672.HTM
>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/forum/t/43502/0/
http://www.4d.fr/documentation/4DDoc67/CMU/CMU11672.HTM
I had this 1067 error when upgrading from 4.1 to 5.
Once I deleted the old 4.1 directory it worked. Path problem maybe.
I deleted c:\mysql and it worked.
Once I deleted the old 4.1 directory it worked. Path problem maybe.
I deleted c:\mysql and it worked.
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\ CurrentCon trolSet\Se rvices\Ora cleJobSche dulerXE
Go there
Ensure image path is
C:\oraclexe\app\oracle\pro duct\10.2. 0\server\B IN\extjob. exe XE
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.
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.
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.