Installing MySQL as a Windows Service

1. Browse to your MySQL's bin folder (e.g. C:\Joget-v4-Enterprise-4.0.2\mysql-5.0.96-win32\bin) in your command prompt.
2. Execute the following. 

   mysqld --install

3. You will get the following when service is installed successfully.

   Service successfully installed.

   You may verify it by going to your Windows's List of Services
   
   

You may encounter error 1067 while trying to start up the service. Possible reasons/solutions are:-

1. Incorrect basedir value. Edit my.ini to include full path to your MySQL folder.

   basedir="C:\Joget-v4-Enterprise-4.0.2\mysql-5.0.96-win32"

2. Incorrect my.ini file loaded. Try to include the full path to the my.ini file in creating Windows service.

   mysqld --install MySQL --defaults-file=C:\Joget-v4-Enterprise-4.0.2\mysql-5.0.96-win32\my.ini