Error In Installing MySQL Server MySQL server cannot be started

	Error In Installing MySQL Server - MySQL server cannot be started
	Discussion by jedipi with 12 Replies. Last Update: November 12, 2012, 8:07 am

jedipi

I try to upgrade my MySQL server from 4.018 to 4.1.10a.
Firstly, I downloaded mysql-4.1.10a (not the essential one) for win XP
Then I install the new version after the old version was uninstalled.

After the installation process, Instance Configurator comes up to help for the configuration.
But an error occured when it try to start the MySQL service.
Error messageis "cannot create windows service for MySQL. Error:0"

So my MySQL server cannot be started. It is running win XP on my computer.
Does anybody can tell me what is wrong?.

Thanks (sorry for my bad english)

Sun Mar 20, 2005 Reply New Discussion

miCRoSCoPiC^eaRthLinG

This is a known problem. Do you remember how you'd to create a MySQL Service and specify a common windows service name for MySQL when you setup 4.018 ? When you simply uninstall MySQL, it removes the present installation - without terminating the service. Under such circumstances, the original .exe file that runs as the windows service doesn't get deleted, and still keeps loading/running in the background. When you try to install a newer version over it, the running service prevents the .exe being overwritten and this generates that error message you're getting.

Your simplest way out, is to re-install the old MySQL again, use it to Stop and Disable the Service and then uninstall it. Next install the newer version.

Second method: Goto Control Panel > Administrative Options > Services. From the list of services, find out the MySQL service and Stop It. Then Disable it from running for good. Next go to the mysql installation directory and remove it entirely. Now you can install the new version without a hitch.

Give it a try and let me know if you succeeded. All the best

Mon Mar 21, 2005 Reply New Discussion

jedipi

I did stop the MySQL service before I uninstall it.
After it was uninstalled, MySQL service was deleted as well.

but taht error message still keep coming up.

So, I opened regedit, and deleted all entries which contain the word "MySql".

then, it works.

Why dose the MySQL uninstaller not just delete those entries.
are those entries keeped for any purpose?

Tue Mar 22, 2005 Reply New Discussion

vhortex

QUOTE (jedipi)

[post="23585"]<{POST_SNAPBACK}>[/post]

If you are on XP with NTFS partitions and service pack 2, things wont work as they used to.

Everything that needs to be uninstalled must have the ownership set to your current logon account and all of the related files (exes and registry) must not be in use or running before they can be deleted or overwritten.

If you are in NTFS system, try to create 2 accounts in windows. One is an admin and one is an ordinary user. Install Microsoft office using the admin account and logoff.

Logon using the normal account and use "microsoft photo editor" which is the standard photo editor of MSoffice. You will then notice that you cannot open any files using that program since the registry is locked to the admin account.

***********

hope this helps.

Sat Apr 23, 2005 Reply New Discussion

mark_fusillade

After banging my head against my keyboard until the S, Q, and L keys sprang out like shrapnel I finally figured out what the problem is and how to solve it.

I was using the MySQL 4.1.11 Installer on my Window XP computer. After the installation completed the installer automatically jumped into the MySQL Server Instance Config Wizard. When the wizard tried to complete the configuration the �Error: Cannot create Windows service for MySQL. Error: 0,� popped up. This is a Windows System Error.

What is happening is a preinstalled MySQL service is installed and recognized in the Windows background. Weather or not it is disabled the operating system will not allow another MySQL service to be installed. To verify this you can check the Services. Do this by clicking on the�

> �Start Menu�
> �Control Panel�
> �Administrative Tools�
> �Services�

The services are listed alphabetically. Scroll down to find MySQL. If you find it you have found your problem. (Incidentally, while I was in here I right-mouse-clicked on the service and opened properties, stopped the service and then disabled the service. The problem still didn�t go away and my head-banging-against-keyboard started up again.) The solution is to remove the service, but there is no option for that in the Services window. To delete the service you need use the command prompt. Start the command prompt by clicking on the�.

> �Start Menu�
> �All Programs�
> �Accessories�
> �Command Prompt�

This will bring up the Command window. To delete the MySQL service type the following�

sc delete mysql

�and hit the enter key. If it is successful the Command Prompt window will give the following feedback.

[SC] DeleteService SUCCESS

For trivia�s sake what you communicate through the Command Prompt window when you type this is�

sc = you contact a command line program used for communicating with the NT Service Controller and services
delete = deletes a service from the registry
mysql = the service that gets deleted

What you do next depend on weather MySQL is still installed. If you didn�t uninstall MySQL click on the�

> �Start Menu�
> �All Programs�
> �MySQL�
> �MySQL Server 4.1�
> �MySQL Server Instance Config Wizard�

Run through the Config Wizard. MySQL should set up with out any problems.

If you already uninstalled MySQL then run though the installer and things should work out.

Fri May 13, 2005 Reply New Discussion

FeedBacker

solution to MySql problem: cannot start service error 0
Error In Installing MySQL Server

This problem usually occurs when you reinstall MySql.

Solution:

1)delete the current installation(windows users go to control panel, then add or remove programs, then select MySql and delete it).
2)Restart.
3)Even though you have uninstalled the software, MySql keeps some files of previous installation. Just go to the directory where MySql was previously installed and delete the entire folder.(Windows users , go to the see:program files, delete MySql folder. In some cases MySql may have been directly installed in see drive, delete the MySql folder from see drive in this case).
4)install MySql once again.
You wont get service cannot be started error 0 this time. Enjoy!

-ash_still_there

Fri Jan 11, 2008 Reply New Discussion

(G)michal

cant instal mysql vistaError In Installing MySQL Server

I've installed and uninstalled mysql so many times those keys are wearing out

I'm on vista iis7 if that matters - PHP is up and running, no apache.

TWO PROBLEMS -

1- still can't start server - I find the HKEY_LOCAL_MACHINEfile /software, but the is no mysql there to take out.

2- while installing mysql server is still up a small windowappears to try to convince you to take mysql enterprise - this windowis too small to allow you to click and go on

(sometimes I get stuck here and sometimes I get to the end install where it cant start server)

Mon Feb 23, 2009 Reply New Discussion

(G)James

I am having the same problem. It is NOT a problem of the old isntallation. I have removed multiple files manually, I have removed the service. I have searched the registry for MySQL, I have searched the hard drive for MySQL and my.Ini. MySQL is GONE. Yet a new version still will not install. People have been reporting this problem for YEARS and they still haven't fixed it?? This is ridiculous.

-reply by James

Sat Sep 5, 2009 Reply New Discussion

HannahI

I never had that problem before, never even heard of it.
Now that you tell me that it is common glad I found this post before that happens to me and I go into trouble like you did.

I'm sorry this happend to you

-Hannah

Wed Oct 28, 2009 Reply New Discussion

(G)marc

I am facing the same problem!

Never had installed My SQL before and did a system restore to make sure if My SQL was pre-installed. Yet, it was not! And still the My SQL 5.1 setup gives me that error message!

Why can't it start the service, if it wasn't there in the first place!

Also, why do I get the error message (error 5, access denied) when trying to manually start the My SQL service after install?

I am installing on Windows Vista SP2

-reply by marc

Sun Dec 27, 2009 Reply New Discussion

(G)saravanan

unable to Reinstall My SQL server 5.0 in windows7Error In Installing MySQL Server

Hi,I have uninstalled mySQL server 5.0 and deleted MySQL folders form C:Program filesMySQL,and C:UserssaravananAppDataRoamingmySQL.Also stopping the services.After,I tried to install,unable to Run "EXECUTE" Step operation,Facing following problems,Connection ERROR : Error No: 1045Access denied for user "root"@localhost (using password: yes)....(big message)

Pls suggest.-question by saravanan

Fri Jun 10, 2011 Reply New Discussion

minamoto

Well i had the same problem as you all do.
The solution doent take much, but you ll have to restart a lot.
Make sure you havent installed navicat or any other software that contains MySQL(except wamp, xamp and other server emulators). If you do uninstall it and delete all the references of it as explained below.

My system is win7 x64
1. Go to services disable MySQL instance(s).
2. Uninstall MySQL
3. Manual delete folder and all of the components of C:\Program Files(x86)\MySQL or C:\Program Files\MySQL
4. Also delete C:\Program Data\MySQL
5. Restart
6. Check in all folders of C:\Users\AppData C:\Users\Default\AppData and C:\Users\yourusernames\AppData for any instance of MySQL
7. Open registry (start button, write regedit and enter) and search for mysql(ctrl+f or edit>find)
8. Delete every instance of MySQL(delete the whole folder) you can find except of other programs that might use it(you must delete MySQL instances of software that you know that they use the version you had installed)
9. Restart
10. Install the version you like and you are done.

If you had a problem in the process or that didnt work, start the process again but restart on every step you made.
If you ve found a lot of registry entries that you dont know where they came from report back and i ll try to help you.

Mon Nov 12, 2012 Reply New Discussion

rapco

There's a related topic that may be useful:
http://www.astahost.com/index.php?showtopic=3430&hl=

It's not only the MySQL server, it php also...

check my post there

Tue Mar 22, 2005 Reply New Discussion