422,363 Members | 2,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,363 IT Pros & Developers. It's quick & easy.

MySQL startup error under Windows Installing MySQL as an Service

P: 1
The service already exists!

The current server installed: C:\AppServ\MySQL\bin\mysqld-nt the --defaults-file=C:\

AppServ\MySQL\my.ini mysql



Try to start the MySQL daemon as service ...



The mysql service starts.

The mysql service failed to start.



System error.



System error 1067.



The process was unexpectedly completed.



Press any key to continue . . .
2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 909
Yur first notice seems to indicate the MySQL is already started. You can check this by doing this on a command =prompt (as Administrator):
Expand|Select|Wrap|Line Numbers
  1. C:\>netstat -antb | findstr "3306 mysql"
  2.   TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING
  3.  [mysqld.exe]
  4.   TCP    [::]:3306              [::]:0                 LISTENING
  5.  [mysqld.exe]
  6.  

You also could try to find out the name of the service by doing this:
Expand|Select|Wrap|Line Numbers
  1. C:\>sc queryex | findstr /i "mysql"
  2. SERVICE_NAME: MySQL57
  3. DISPLAY_NAME: MySQL57
  4.  
And thn query the information of this service with:
Expand|Select|Wrap|Line Numbers
  1. C:\>sc qc MySQL57
  2. [SC] QueryServiceConfig SUCCESS
  3.  
  4. SERVICE_NAME: MySQL57
  5.         TYPE               : 10  WIN32_OWN_PROCESS
  6.         START_TYPE         : 3   DEMAND_START
  7.         ERROR_CONTROL      : 1   NORMAL
  8.         BINARY_PATH_NAME   : "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57
  9.         LOAD_ORDER_GROUP   :
  10.         TAG                : 0
  11.         DISPLAY_NAME       : MySQL57
  12.         DEPENDENCIES       :
  13.         SERVICE_START_NAME : NT AUTHORITY\NetworkService
  14.  
This should help you with "The service already exists!", if not try to give what your system responded on above example
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.