People often checks MySQL's download section and when they notice that there is new version of MySQL released they just can't wait for a second & starts downloading it so that they can install it on their windows box for testing purpose. Ok fine, download is completed its time to install it. Couple of successful "NEXT" and In the last step they encounter a error message such as
"Cannot create Windows service for MySQL.Error:0" We are so intelligent ppl that we don't want to take any help from our colleague.. And what we do is we just delete the directory in which new installation has been done & starts the installation wizard one-more time in the hope that this time we gonna install it. Again the result is same "Cannot create Windows service for MySQL.Error:0" So why are we getting error that too at the last step? one common thought is "there must be something wrong or some sort of bug in the new release" How to resolve this error? The primary reason for this error is that you haven't properly uninstalled the previously installed MySQL server & in the installation wizard last step was to create the service with the name "MySQL" and which has the same name as that of the existing service (default is "MySQL"). Solution for this error is to first stop the service if it is running and then remove the service. C:\>NET STOP MYSQL The MySQL service is stopping. The MySQL service was stopped successfully. Once the service is stopped, it can be removed with the SC utility: C:\>SC DELETE MYSQL [SC] DeleteService SUCCESS With the previous service stopped and removed, you can now run the MySQL Configuration Wizard again to configure and start the new MySQL service.