error during start MySQL service

[goldeneaglesteam]

hi,
I have trial of the latest advanced installer,
I loved it.

I try to build a project c# with MySQL
- I downloaded MySQL server 5.7.17 (no install) and configured it. then a put it in my c# project folder.
- now I try to install MySQL server from this folder by "advanced installer services tab"
- I create new service but the service can't start. " service " servicename " failed to start. Verify that you have sufficient privileges to start system service.
i tried to start it with command "net start servicename"

and this error appear:

The service is not responding to the control function.

More help is available by typing NET HELPMSG 2186.

Capture.PNG (26.39 KiB) Viewed 4119 times

Capture02.PNG (25.47 KiB) Viewed 4119 times

Capture01.PNG (18.43 KiB) Viewed 4119 times

The attachment Capture4.PNG is no longer available

[Daniel]

Hello,

To install and configure MySQL Server I would recommend you to use their dedicated Windows Installer setup package. Just download the MySQL MSI installer from their web site and add it as a prerequisite to your main setup package.

Also, to install and configure the MySQL service try to use their MySQLInstallerConsole.exe configuration tool. Just take a look on their docs about how to install and configure MySQL on Windows:

1. MySQL Installer for Windows
2. MySQLInstallerConsole Reference

Also, you can have a look on our "MySql server installation fails with MySQLInstallerConsole as custom action" thread on our forums where I created and attached a setup project which silently install the MySQL Server (check "Prerequisites" page) and then configure the MySQL service at the end of the installation (check "Custom Actions" page).

All the best,
Daniel

[goldeneaglesteam]

thank you ..
as your reply here :
viewtopic.php?f=2&t=21072

this error appear :

Capture6.PNG (13.72 KiB) Viewed 4099 times

i tried to install the service by command

Code: Select all

mysqld --install servicename

the service installed successfully

[Daniel]

I'm glad you got this working.

Let us know when you have further questions or doubts.

All the best,
Daniel

[shellm]

Hello goldeneaglesteam,

in case this problem is still not completely resolved, I have created a similar installer. I use the .zip files for MySQL 5.7.21 with AI 14.7.
Service install happens with custom actions in my scenario, see the attached screenshots.

You can find the .zip downloads at https://dev.mysql.com/downloads/mysql/


This one initializes the data directory with settings made in my.ini (I use a .txt-Update to create a custom my.ini with AI Enterprise)


This one then registers the mysqld.exe as a windows service.

Until now, this worked fine for me. Created this routine in AI 14.3 with MySQL 5.7.18 and upgraded it with every release.

Greetings from Germany,
Simon

[Daniel]

Hello Simon,

Thank you for sharing your solution with us. Much appreciated.

All the best,
Daniel