mysql configuration stops at "starting server"

Question

I was installing MySQL installer on my windows 8 machine. During the server configuration process, it gets stuck at "starting server" and doesn't move any further. The log for the same is :

Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating firewall
Adding firewall rule for MYSQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding a new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

I have already tried the following:-
* Un-installed all the programs that were in any way related to MySQL.
* Deleted the MySQL folder from C:\Program Files.
* Cleared my registry.
and then re-installed the program, but all in vain.

The link MySQL Installer Stuck on "Starting Service" also shows the same problem but the solution provided is not working for me.

sometime it stuck in the UAC process. try to manually start the server and get the error code. delete the server-data: any corrupted table files? did the installation complete? check if mysql.ini is present — Krish, Nov 17 '14 at 11:16
I have fixed it by my answer [here][1] [1]: http://stackoverflow.com/a/30104268/3745869 — user3745869, May 07 '15 at 14:47

score 108 · Answer 1 · answered Mar 24 '15 at 21:30

108

Here is what I did:

Installed it with mysql-installer-web-community-5.6.23.0.msi
For my purposes I selected "Custom" install with MySQL servers 5.6.22 - X64 and MySQL Connectors -> Connector ODBC/5.3.4 - 64
Next -> Execute -(ready to configure) -> Next
Config type: Development machine, all defaults (TCP/IP, Port: 3306, Open firewall)
Typed in MySQL Root Password
MySQL user Accounts -> Add user (username, password, OK) -> Next
Configure MySQL Server as a Windows Service (CHECKED)
Windows Service Name: MySQL56 (default)
Start the MySQL Serve at System Startup
THIS IS CRUCIAL (BUG IS HERE): Run Service as... Standard System Account (CHECKED - but it will be disregarded and that is BUG)
Next -> Execute, Installation hangs on Starting server, so wait for a while to time out (or don't, your choice). When Dialog (might be covered with other windows) popup with message "Configuration of MySQL Server is taking longer than expected..., here click OK (so to wait longer)
Meanwhile go to Start -> Control Panel -> Administrative Tools -> Services -> find MySQL56, right click on it -> Properties -> select Log On Tab AND HERE IS BUG -> Although Local System Account was selected, Somehow "This account: Network Service (with some password) was selected -> Select Log on as: Local System Account, Allow service to interact with desktop -> Apply -> Go back on general tab
On general tab click on "Start" button to start service and here it is! Service is started! Click on OK to close MySQL56 Properties dialog. Close Services dialog. Close Administrative tools. Close control panel.
And by that time (while you were closing those dialogs) when you look at MySQl Installer Dialog all steps are finished and checked: Starting Server, Applying security... Creating user accounts.. Updating Start menu link
Confirm with Finish -> Next -> Finish

That's it, happy MySQL-ing :)

answered Mar 24 '15 at 21:30

Nenad Bulatović

6,970
13
74
109

2

Thanks so much -- I was doing this with 5.7 and had to stop the service first -- for me that was step 12.5 – BitsAndBytes Jul 08 '15 at 14:57
2

It worked for version 5.7.10 on windows 7 x64. Thanks – Jorge Zapata Dec 23 '15 at 06:51
Step12, After started the server, if the configuration still not continue, click Cancel and than "No", – Oktay May 09 '16 at 19:30
1

Thanks a lot for this solution! MySQL 5.6.28 with win7 32bit worked. – Bill Hoo May 17 '16 at 05:44
3

Worked for me in Windows 10. Same issue is there for MySql 5.7 installer too – manikanta Apr 15 '17 at 05:37
1

Take note that if your ROOT user has a semicolon in the password (;) then the installer fails at the "Starting Server" step. This bug has been logged here: https://bugs.mysql.com/bug.php?id=77840 – RiaanP Apr 26 '17 at 12:41
7

Unfortuantely, it doesn't work. It gives me another error whenI start the service: `MySQL service on local computer started and then stopped etc ...` . Any help ?! – McLan Oct 11 '17 at 11:53
2

Wow 2019 and still this bug exists in v8 installing onto W2K12 – Steve Feb 07 '19 at 19:46
I tried this answer and my configuration stops on the next step. The solution was simple, I forgot to stop the mysql service from xamp, now that's ok. – T. Borges Mar 07 '19 at 21:32
2

This "bug" is still present in 8.0.17. Maybe it'd be easier for Oracle to add your instructions (or a link to this page) to the installation wizard - then it's no longer a bug, and somehow improves the user experience – Mark Hebert Sep 18 '19 at 20:44
1

Works for me on Windows 10 Pro (1607) with MySQL 8.0.17.0 – Dragan Menoski Sep 26 '19 at 11:48
1

Still present in 8.0.18 and this fixed it on Windows 10 Home. – Alex Oct 18 '19 at 11:13
When I press start, it says: "Windows could not start the MySQL80 service on local computer. Error 2: The system cannot find the file specified" what to do now? – icyNerd Nov 23 '19 at 15:48
5 years later and Oracle still doesn't care about this bug, thank you! – MPJ567 May 11 '20 at 21:05
Only step 12 and 13 needed to fix this for mySql80 on Windows Server 2019 – itsLex Sep 09 '20 at 16:03
Thanks so much. Works for MySQL Server 8.0.22 – vickson Nov 04 '20 at 10:17
Thank you SOOOOOOOOOOOOOOO much! The step 12 was the key to be able to activate the service and finish the installation! :D – McFly Apr 12 '21 at 04:11
bug still exists for 8.0.25. Solution Worked. Thanks. :) – kmasif Jun 23 '21 at 13:55

score 6 · Answer 2 · 2017-06-29T14:03:19.380

The installer has another issue that I discovered today.

I had the same issue of the installer hanging on "Starting Server". However, after looking at the windows Event Viewer under Windows Logs -> Application, I discovered the error

"Too many arguments (first extra is 'Something').For more information, see Help and Support Center at http://www.mysql.com.".

The issue is that the installer cannot handle spaces in the windows service name (the name I used was Something MySQL). Simply change the name to one without spaces.

score 2 · Answer 3 · edited Jan 31 '19 at 10:15

2

The MySQL developers insist that running the MySQL service Logged On as NETWORK SERVICE IS the proper way to do it and that running it as LOCAL SYSTEM opens security holes. Okay, people, the root of the problem here is that NETWORK SERVICE can't access the locations where the log files are configured to be. I suspect this error occurs when a folder is specified (by clicking Browse) that the NETWORK SERVICE doesn't have access to. In my case, I specified the log files to be written under My Documents in a folder called MySQL Logs. So, (and this can be done while the installer dialog is open, it says the installer is taking a long time, and prompting you to Wait or Cancel,):

I simply granted full control of that folder to the NETWORK SERVICE by right-clicking on the folder, selecting Properties, selecting Security, then clicking Add, then typing in "NETWORK SERVICE". Then I selected NETWORK SERVICE and clicked the checkboxes Allow for Full control and Modify.

edited Jan 31 '19 at 10:15

DJo

1,997
2
28
46

answered Mar 14 '18 at 11:37

Emagine

46
3

Please have a look at [this answer](https://stackoverflow.com/a/29243268/8283469) on the same question, it's highly upvoted and your answer is quite late. Do you really think your answer is required and adds some new quality to this post? – L. Guthardt Mar 14 '18 at 12:02
1

Yes, as MySQL was not meant to run with Local System Account privileges—it gives it too much access. Adding "Full control" privileges to the directory or directories where the log files will be located to the NETWORK SERVICE account gives MySQL the access it needs, and allows it to run with the privileges intended. See https://bugs.mysql.com/bug.php?id=76476, which says "The use of Local System Account (NT AUTHORITY\SYSTEM) is highly discouraged because is a very high-privileged built-in account and has extensive privileges on the local system. ..." – Emagine Mar 19 '18 at 03:38
Thanks, this was a helpful explanation / summary conclusion of my situation. – stuzor Jul 29 '20 at 06:14

CraftsmanWannaBe · Answer 4 · 2018-12-06T20:31:53.963

2

My issue was the special character in the password.

What I did to resolve being stuck at the Attempting to Start Server:
1. Use the installer to uninstall the previous version/installation
2. Validate and delete the existing MySQL Folders (DATA and App)
3. Re-install using the installer
4. Use a strong lengthy password with no special character password

edited Dec 06 '18 at 20:31

answered Dec 06 '18 at 16:21

CraftsmanWannaBe

21
2

score 1 · Answer 5 · answered Aug 18 '16 at 22:00

This seems to be a chronic issue with MySQL Installer even now (v1.4.17.0). No matter what, every time I (re-)configure an instance on Windows 7 Pro or Server (2008 R2) it hangs at this point.

Simplest fix is:

When the installer hangs, open Windows Services and locate your mySQL service instance(s).
Double-click to open the/an instance and set Log on as: to Local System account and check Allow service to interact with desktop.
Optionally but preferably set the Recovery options to allow the service to resume after a problem.
Ensure that Startup type is set to Automatic (or whatever your preference is).
Click Apply and then click Start (or click OK and then start the service).
Return to the MySQL Installer and close any open warning about waiting for the process to complete and the process should continue.
Repeat as required for each MySQL Server instance.

Note: The installer seems to not enable the firewall exception that you may have selected when MySQL Server was first configured, so you may have to reconfigure again to open the firewall.

Side note: All-in-all, I'd have to say that after only two days of using the MySQL ecosystem, I'm less than impressed by how buggy things are. I would estimate that I had to set up two server interfaces about 6 times before everything worked as advertised. Workbench crashed on me 5+ times in the first day alone and I've had to traipse through any number of forums finding answers to stuff like this. Be prepared to do the same.

score 1 · Answer 6 · answered Jan 28 '18 at 03:17

I had the same problem where it changed from Local System Account to Network Service, I changed it in the services back to Local System Account. This however did not work. I came across another forum that suggested having spaces in the services name was causing the problem so I took out the spaces and put underscores and sure enough it worked!

Change spaces to underscores!

score 1 · Answer 7 · answered Jul 29 '18 at 13:27

Adding this for others.

I had install set up to configure windows service.

Looking in Windows Event Viewer => Windows Logs => Application I found:

C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Error while setting value '0.0' to 'lower_case_table_names'

Checking the init file in C:\ProgramData\MySQL\MySQL Server 5.6\my.ini

I found:

# Specifies the on how table names are stored in the metadata.
# If set to 0, will throw an error on case-insensitive operative systems
# If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive.
# If set to 2, table names are stored as given but compared in lowercase.
# This option also applies to database names and table aliases.
lower_case_table_names=0.0

I changed the value to 0, but on reinstall it reappeared as 0.0 so during the install and whilst the installation hanged at 'Starting Server' I edited the my.ini file, saved it, opened the services viewer and manually started the service MySql56. The installation then completed

Using value 0 is incorrect for windows, so I manually set it to 1 and restarted the service. — Richard France, Jul 29 '18 at 13:43
This pointed me to the right direction. In my case my 32bit instance (required by an old software) was being set with a 10G buffer (not allowed above 4G for 32bit version). — A. Perez Cera, Apr 08 '21 at 07:16

Mukus · Answer 8 · 2015-03-25T07:33:13.310

I've figured this one out. Mine was getting stuck at "Starting Server" too and Event Viewer had this -

The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.    
If the event originated on another computer, the display information had to be saved with the event.    
The following information was included with the event:     
innobase_buffer_pool_size can't be over 4GB on 32-bit systems

So I figured out the problem was trying to start the 32-bit version of MySQL that comes bundled in with the installer on a 64-bit machine could have been the problem. Although, MySQL states it will install 64-bit of the database.

What I did was downloaded a 64-bit zipped version and unpackaged it into a temporary location. I re-ran the installer and let it install mysql. I replaced the contents of that with the other version from the temporary location without stopping the installer. Then I continued with configuration steps of the installer. It managed to start the service.

Here's full trace of the log.

Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating firewall
Adding firewall rule for MySQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

Beginning configuration step: Starting Server
Starting MySQL as a service
Ended configuration step: Starting Server

Beginning configuration step: Applying security settings
Attempting to update security settings.
Updated security settings.
Ended configuration step: Applying security settings

Beginning configuration step: Creating user accounts
Attempting to Add New MySQL Users
Added New Users.
Ended configuration step: Creating user accounts

Beginning configuration step: Updating Start Menu Link
Attempting to verify command-line client shortcut.
Verified command-line client shortcut.
Verified command-line client shortcut.
Ended configuration step: Updating Start Menu Link

mysql site

"Then I continued with configuration steps of the installer." So, you had to stop installer? Did it ask you for a administrative password when you restarted it? Mine installed stucks in that too. It loops indefinitely like it can't check password I previously configured. — Nenad Bulatović, Mar 24 '15 at 19:31

score 0 · Answer 9 · answered Nov 02 '17 at 17:28

0

I found another solution: I was using a complex password with special characters in it. When I switch to using only alphanumeric characters in the password, it installed with no issues.

answered Nov 02 '17 at 17:28

engpharmer

1
2

score 0 · Answer 10 · edited Aug 23 '18 at 05:32

I faced the same problem. Completely removing MySql from my PC and then installing it from scratch fixed my problem.

How to remove MySql Completely:

Run Command Prompt as Administrator and execute the following command to stop and remove MySQL service.
```
Net stop MySQL
Sc delete MySQL
```
Go to Control Panel >> Programs >> Programs and Features, select MySQL Server 5.x and click Uninstall. (If you can uninstall MySQL from Control Panel)
Open Windows Explorer and go to Organize > Folder and search options, Select the “View” tab and under “Hidden files and Folders” choose “Show hidden files and folders”. Now explore the following locations and delete following folders.
- C:\Program Files\MySQL
- C:\Program Files (x86)\MySQL
- C:\ProgramData\MySQL
And if this exists, delete it too:
```
C:\Users\[User-Name]\AppData\Roaming\MySQL
```
Restart your PC and reinstall MySQL. That’s all!

score 0 · Answer 11 · answered Jan 31 '19 at 01:49

I made this problem disappear by upgrading from 5.7 to 8.0.

Specifically I:

Uninstalled MySQL 5.7 (through the "MySQL Notifier").
Downloaded and ran mysql-installer-web-community-8.0.14.0.msi from https://dev.mysql.com/downloads/windows/installer/8.0.html

score 0 · Answer 12 · answered Jul 23 '20 at 20:29

None of the above solutions worked for me. I finally installed an older version. You can look at the version release history from here. Instead of installing the latest MySQL version 8.0.21.0, I instead installed version 8.0.18.0 from here. It finally worked.

mysql configuration stops at "starting server"

12 Answers12

Linked

Related