Could Not Start The Service Mysql. Error 0 Mysql 5.5
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top could not start the service MySQL. Error:0 how to get mysql 5.5 server running? up vote 0 down vote favorite I tried to upgrade to MySQL 5.5 from 5.1. When I try to run Instance Configuration Wizard I get this error: Could not start the service MySQL. Error:0 I am to the point now that I would be happy just to have a fresh install of MySQL 5.5. I can repopulate the database after. Things I have tried: Restart the machine and try Instance Configuration Again Uninstall all MySQL software and making sure that there was no service and reinstall search registry to make sure there was no MySQL entries. I tried to check the .err log, but there was none to be found. Googled online to see if anyone was having same issue. Several people were but there was no simple solution. Followed this guideline step by step but still no success Information that I have: OS: WINDOWS XP Service Pack 3 after running mysqld -nt --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" in cmd this is outputted: --standalone --console >>output.txt 111109 10:09:33 [Warning] option 'new': boolean value 't' wasn't recognized. Set to OFF. 111109 10:09:33 [Note] Plugin 'FEDERATED' is disabled. 111109 10:09:33 InnoDB: The InnoDB memory heap is disabled 111109 10:09:33 InnoDB: Mutexes and rw_locks use Windows interlocked functions 111109 10:09:33 InnoDB: Compressed tables use zlib 1.2.3 111109 10:09:33 InnoDB: Initializing buffer pool, size = 47.0M 111109 10:09:33 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file .\ib_logfile0 is of different size 0 104857600 bytes InnoDB: than specified in the .cnf file 0 25165824 bytes! 111109 10:09:33 [ERROR] Plugin 'InnoDB' init function returned error. 111109 10:09:33 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 111109 10:09:33 [ERROR] mysqld: unknown variable 'defaults-file=C:\Program Files \MySQL\MySQL Server 5.5\my.ini' 111109 10:09:33 [ERROR] Aborting 111109 10:09:33 [Note] mysqld: Shutdown complete Here is what is in my.ini: # MySQL Server Instance Configuration File # ---
Email Updates: Status: Closed Impact on me: None Category:MySQL Server: Installing Severity:S3 (Non-critical) Version:MySQL 5.5.25-win64 OS:Microsoft Windows (Win7 Home Premium 64bit) Assigned to: Tags: FIXED!! View Add Comment Files Developer Edit Submission View Progress Log Contributions [21 Jul 2012 17:01] Domtican Kipas Description: X mark on Start Service Error Message: Cannot Create Windows Service for MySQL. Error:0 How to repeat: Setup: Custom Setup Clicked Development Components MySQL Server Instance Configuration: Detailed Config Server Machine Multifunctional Database Manual Setting (50 concurrent conn) checked firewall exception Multilingaulism included bin directory clicked execute X http://serverfault.com/questions/329298/could-not-start-the-service-mysql-error0-how-to-get-mysql-5-5-server-running mark on Start Service Error Message: Cannot Create Windows Service for MySQL. Error:0 [21 Jul 2012 17:46] Valerii Kravchuk Do you run this installation process as Administrator? [22 Jul 2012 4:48] Domtican Kipas Yes. [22 Jul 2012 7:50] Valerii Kravchuk Please, send the content of MySQL server's error log. This is usually a file named
5.1. Despite endlessly googling them internets and browsing through the MySQL documentation, the solution was nowhere to be found. Fortunately for you, I found the ultimate fix to this problem in 8 easy steps! Huzzah! https://schalbroeck.wordpress.com/2009/04/22/mysql-installation-could-not-start-the-service-mysql/ This fix is aimed at Windows Vista users, although it should be pretty much the same for XP/2000. PROBLEM: The error "could not start the service mysql" pops up the moment you try to re-install MySQL server. The reason why you're getting this error is because there are still traces of the previous installation left on your computer, that are not removed during uninstall. SOLUTION: STEP 1 - If you still could not have MySQL installed, go to the MySQL Server Instance Config Wizard and choose remove instance. After that, go to Programs and features in the control panel, and uninstall MySQL server. STEP 2 - Now find the MySQL directory in your installation directory (e.g. c:\program files) and delete it. STEP 3 - Bring up a command prompt (press windowskey + r and type cmd.exe (enter)) and insert the following command: "sc delete mysql" could not start without the brackets. After executing it should say that the service has been removed from the system. STEP 4 - Press windowskey + r and enter "%appdata%" without the brackets. Now find the MySQL folder and delete it. STEP 5 - Press windowskey + r again, enter "%programdata% and delete the other MySQL folder. STEP 6 - Open regedit and go to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services, here you'll find a MySQL registry key (see screenshot), delete it. Do a search for all MySQL entries (press F3) and kill them. MySQL key in regedit (click to enlarge) STEP 7 - Now for the last step, you should search your system for any leftover MySQL directories, or "my.ini" files, and delete them. STEP 8 - Now reinstall MySQL server, I recommend installing it in a different directory than the previous installation. That's it! Your new MySQL installation should be up and running now! PS: Please leave a comment if these steps didn't work for you. PPS: Please leave a comment if these steps did work for you😀. Last modified on August 10 2009 Like this:Like Loading... 37 Comments Sir you are a life saver! Thanks! posted August 5, 2009 at 1:50 am by john Reply 5.0.81. Did it. And then again failed to start. I was li