This did the trick for me: Show
https://serverfault.com/questions/214435/error-1067-the-process-terminated-unexpectedly-when-trying-to-install-mysql-on/214846#214846 Of course, in this case, you have to completely clean up the xampp folder, which doesn't always happen. I guess I backed up the necessary files first (data folder from mysql folder and the htdocs folder). Uninstall XAMPP. Check the xampp folder for any content that remains and delete everything. You may want to reboot afterwards, just in case. Then reinstall XAMPP. Copy the backed-up folders back to their respective places, and hopefully, mySql will work again in XAMPP. XAMPP error 1067 mysql doesnot start sol frm forum dont workProblems with the Windows version of XAMPP, questions, comments, and anything related. XAMPP error 1067 mysql doesnot start sol frm forum dont workI have installed XAMPP. the installation went fine the XAMPP also works as a service but the mysql database doesnot start from XAMPP control panel. if i go into services from SCM panel on XAMPP control panel and try to start mysql database it gives a error 1067 the process terminated unexpectedly. i have seeen many such queries in this forum but none of the answers are helping me. I am using windows XP operating system. i tried checking the firewall settings and port settings. firewall is on and in exceptions mysql port is set to 3306 TCP. i have AVG free and antivir free installed on my machine. i tried to explore these antivirus but no place do i get options that block mysql. i am a total newbee. i am totally stuck and need help urgently. can anyone help me by giving step by step explanation bkamat Posts: 4Joined: 29. October 2008 08:58
by Sharley » 29. October 2008 09:55 It always helps find a solution if you give the details of what you have tried already. Try this: Close the Control Panel Go to the folder .\xampp\mysql\ and run the mysql_uninstallservice.bat file. Go to the folder .\xampp\ and run the mysql_stop.bat file. Now check that no mysql program is running on your system by right clicking on the Task Bar, select Task Manager from the context menu. Now select the Processes tab and look for mysqld.exe or mysqld-nt.exe Now go back to the .\xampp\ folder and run mysql_start.bat and see if there is an error message returned. If there is an error message paste it back here. If not then close the bat file command console window and open your Control Panel again and try starting your Apache and MySQL again. Sometimes if the service is already running and you try and start MySQL again or it has not been shutdown properly before, sometimes by a system error perhaps, it may give errors. SharleyAF Moderator Posts: 3316Joined: 03. October 2008 05:10Location: Yeppoon, Australia Time Zone: GMT/UTC+10Operating System: Win 7 Pro 32bit/XP Pro SP3 tried it. heres the error messageby bkamat » 29. October 2008 15:24Hi thanks so much for responding. i desperately needed help. i tried your suggestions. there is no file by the name mysql_uninstallservice.bat in the folder .\xampp\mysql\. instead i tried xampp_stop.exe. then i opened process tab from task bar to ensure there in no apache and mysql running. mysql was not running. then i started file mysql_start.bat from .\xampp\ folder. below is the error shown on the console. and mysql didnot start. my computer name is com4 on our intranet Diese Eingabeforderung nicht waehrend des Running beenden MySQL konnte nicht gestartet werden after this i started XAMPP control panel and started apache and my sql. the apache service started but mysql service started and stopped. hope this can give u an idea of my problem. please let me know if u have a solution. thanks [/url] bkamat Posts: 4Joined: 29. October 2008 08:58
by Wiedmann » 29. October 2008 15:26
That'S a bad name. Best is to rename your computer. WiedmannAF Moderator Posts: 17102Joined: 01. February 2004 12:38Location: Stuttgart / GermanyOK will change nameby bkamat » 29. October 2008 15:29OK thanks will change name to internet. or as u suggest. but why is com4 a bad name. and can u suggest more based on error message i have pasted. bkamat Posts: 4Joined: 29. October 2008 08:58
by Wiedmann » 29. October 2008 15:37
Some programs, like MySQL, are using the computername for e.g. a temp-, log-, pidfile. But "com4" is a reserved word on Windows and can't be used in a filename. WiedmannAF Moderator Posts: 17102Joined: 01. February 2004 12:38Location: Stuttgart / Germanychanging name worksby bkamat » 29. October 2008 15:54Hi thanks so much i changed the computer name to internet1 and restarted the machine. i started the XAMPP and started mysql. it doesnot stop now. PHPMYADMIN has started to work. wow sometimes we make so stupid mistakes. thanks for your common sense i can start working now. bkamat Posts: 4Joined: 29. October 2008 08:58
Re: XAMPP error 1067 mysql doesnot start sol frm forum dontby mpg187 » 26. February 2011 03:44I am getting the same error. I can run the batch file to start it but would rather just have it as a service so I don't have to run the batch file all the time. Here is some info that might help:
mpg187 Posts: 4Joined: 10. November 2010 04:32Location: Operation420.net most of the time...
Return to XAMPP for Windows Who is onlineUsers browsing this forum: No registered users and 202 guests How do I fix error 1067 the process terminated unexpectedly in MySQL?How to Fix Error 1067: 'The process terminated unexpectedly'. Solution 1: Take Control of the Service.. Solution 2: Reinstall the Problematic Service.. Solution 3: Delete Certain Files.. Solution 4: Tweak MySQL Configuration Files.. Solution 5: Reinstall SQL Server.. Solution 6: Method for EAServer Windows Service.. What is Error 1067 The process terminated unexpectedly?The Error 1067 error code is caused by Windows system malfunction. Corrupted system files are usually a real danger to the performance of a computer. This damaged system file will result in missing or wrongly connected data and data files needed for the optimal working of the application.
Can't start MySQL service on local computer?You can check this by locating the my. ini file, located in your Windows installation directory (by default C:\Windows\) and opening it up in a text editor to verify that there are no duplicate entries. If there are, delete the duplicated entry and attempt to start the MySQL service again.
|