Bug #92683 Mysql server 8.0.12 windows service install or mysqld issue
Submitted: 5 Oct 2018 10:11 Modified: 12 Oct 2018 13:08
Reporter: lionel mazeyrat Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:8.0.12 OS:Windows (Server 2016)
Assigned to: CPU Architecture:Any

[5 Oct 2018 10:11] lionel mazeyrat
Description:
After installing mysql windows service, and launching it,
2 mysqld.exe process are launched.

For the first the command line reported :

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" MySQL80

For the first the command line reported :

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" "--defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini"

How to repeat:
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --remove MySQL80
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --install MySQL80 --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini"
[5 Oct 2018 10:16] lionel mazeyrat
-
[5 Oct 2018 11:07] MySQL Verification Team
Thank you for the bug report. I am a little confused here, on my computer the Windows MySQL installer placed the my.ini file in below path:

C:\>"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --install MySQL80 --defaults-file="C:\Program Files\MySQL\MySQL Server 8.0\my.ini"
Service successfully installed.

instead of:

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --install MySQL80 --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini"

C:\Program Files <> C:\ProgramData

Please check. Thanks.
[5 Oct 2018 12:15] lionel mazeyrat
mysql service

Attachment: mysql.png (image/png, text), 298.48 KiB.

[5 Oct 2018 12:17] lionel mazeyrat
I've removed the service and reinstalled it if with :

C:\>"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --install
MySQL80 --defaults-file="C:\Program Files\MySQL\MySQL Server 8.0\my.ini"

I still have 2 mysqld lainched each time I start the service.

See File attached
[5 Oct 2018 12:52] MySQL Verification Team
Thank you for the feedback.
[9 Oct 2018 7:48] Thayumanavar Sachithanantham
In 8.0 the one instance of the mysqld is the monitor process which monitors 
the mysqld that serves the requests. 
This is the default behaviour. This is required RESTART sql implemented. If 
this is not required, the server can be started with the option --no-monitor.
[9 Oct 2018 18:53] lionel mazeyrat
thanks for the reply
[12 Oct 2018 13:08] Paul DuBois
Posted by developer:
 
Addition to
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
under "Additional Installation Information":

To accommodate the RESTART statement, the MySQL server forks when run as a service or standalone, to enable a monitor process to supervise the server process. In this case, you will observe two mysqld processes. If RESTART capability is not required, the server can be started with the --no-monitor option. See Section 13.7.7.8, “RESTART Syntax”.