Jump to content
xisto Community
jedipi

Error In Installing MySQL Server MySQL server cannot be started

Recommended Posts

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 XPThen 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)

Share this post


Link to post
Share on other sites

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 :D

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

<{POST_SNAPBACK}>


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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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)

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

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. :DI'm sorry this happend to you :P-Hannah

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

 

Share this post


Link to post
Share on other sites

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 x641. Go to services disable MySQL instance(s).2. Uninstall MySQL3. Manual delete folder and all of the components of C:\Program Files(x86)\MySQL or C:\Program Files\MySQL4. Also delete C:\Program Data\MySQL5. Restart6. Check in all folders of C:\Users\AppData C:\Users\Default\AppData and C:\Users\yourusernames\AppData for any instance of MySQL7. 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. Restart10. 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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.