the MySQL service on local computer started and then stopped

MysqlServiceWindow

Mysql Problem Overview

the MySQL service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

Can anyone resolve this issue? Thanks.

Mysql Solutions

Solution 1 - Mysql

After installing it by mysqld --install. Try this mysqld --initialize. We got the same problem but it's now working.

Solution 2 - Mysql

If using version 8 and you edit the my.ini I found that Notepad is putting 3 hex characters at the beginning of the my.ini file. EF BB BF. Deleting the 3 characters from the beginning of the file in a hex editor fixes the problem.

In version 8 they are accidentally putting Unicode characters in the ini file. This is causing Notepad to save the file with Byte order mark characters.

The following line in the file is the culprit "The line # range from 1 to 2^32 − 1. “Unique” means that each ID must be different." has 3 Unicode characters. This is causing notepad to append the byte order mark to the text file.

Solution 3 - Mysql

Also remember to give NETWORK SERVICE permission to the folder:

  1. Right-click Data folder
  2. Select Properties
  3. Select Security tab
  4. Click Advanced
  5. Click Change Permissions...
  6. Click Add...
  7. Type NETWORK SERVICE
  8. Click Check Names
  9. Click OK
  10. Select Full Control
  11. Click OK – four times
  12. Start MySQL service

Solution 4 - Mysql

In my case, I tried to open a DOS prompt and go to the MySQL bin\ directory and issue the below command:

mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" --standalone --console

And it shows me I was missing the "C:\Program Files\MySQL\MySQL Server 5.0\Uploads" folder; I built one and problem solved.

Solution 5 - Mysql

  1. Open Service
  2. Right click on MYSQL service
  3. select Log on
  4. check local system account
  5. start service

Solution 6 - Mysql

Using Community 8.0.17, upgraded from 8.0.16

There may be a more secure way of doing this, but since I'm just running a dev box:

  1. navigate to the \data folder
  2. make SURE the \data folder is EMPTY. If files exist the --initialize option will fail
  3. give SYSTEM Full Control permissions on the \data folder
  4. go back to your command prompt
  5. run mysqld --initialize

you should see all of the required data file structures in the data folder now. If they are not created, the mysqld process has contention or improper security to write into the folder correctly.

Now start your named service in whatever fashion you want (SC/NET/service.msc, etc)

Assuming all of the files were created properly by --initialize the service will start.

Solution 7 - Mysql

This may be because of changing lower_case_table_names after a server has been already initialized.

From the docs: > lower_case_table_names can only be configured when initializing the > server. Changing the lower_case_table_names setting after the server > is initialized is prohibited.

The solution to this problem is to set lower_case_table_names parameter at server installation as described in the following answer:

Can't set lower_case_table_names in MySQL 8.x on Windows 10

Solution 8 - Mysql

I see this error when I install MySQL 8.x, edit the max_allowed_packet in the my.ini file, and then restart mysql on a Windows 10 machine. My recommendation, to avoid this issue, is to edit the my.ini file in a hex editor (something like Frhed). DO NOT USE NOTEPAD. It does something to the hex layout of the .ini file.

Solution 9 - Mysql

Follow the below instruction as below to save your day:

If you modify my.ini not correct, you will find the trouble "the MySQL service on local computer started and then stopped". So you need to check your my.ini in "C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" again to make sure there is no strange command. If you don't know and want to restore to original, you can search on web with key word "my.ini configuration", download the latest and copy it to "C:\ProgramData\MySQL\MySQL Server 8.0\my.ini"

For whom delete the SQL service on Window or Linux, You can follow these step below:

(Window)

Delete Current Service

You need to stop MySQL80/MySQLXX in Service before carry out the action below Open commandLine of Window and run as administrator

sc delete mysql80 <= If you use mysql80, it will delete MySQL80 in Service

sc delete mysql <= If you use "mysql --initliaze", it will delete MySQL in Service

The command mysqld --initialize just create MySQL in Service of Window or Linux

So when you check it Path Executable, it misses my.ini so you can't use you MySQL Server although MySQL Service is working

For 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"

For MySQLXX

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

=> It will create MySQLXX Service working with my.ini

Then MySQL works normally and you won't need to install your MySQL again.

I don't use Linux or Mac so I can't instruct - But you can find the answer above for reference

Solution 10 - Mysql

This error happened in my case when secure-file-priv was pointing to unexistent folder, make sure it exists and readable.

The line of code example in my.ini: secure-file-priv="D:/MySQL/uploads"

Solution 11 - Mysql

You also might have accidentally added some wrong text in my.ini file. Make sure no invalid character is added at the beginning of the file.

Solution 12 - Mysql

Nothing was working for me but then I checked here. I ran that command qc sc mysql57 and copied the value of BINARY_PATH_NAME from it. After that I checked this and changed the value of lower_case_table_names from 0 to 2 in my.ini file. Then in the command prompt, I ran this command - << BINARY_PATH_NAME >> --install-manual. After that, I started the MySQL57 service and it worked.

Solution 13 - Mysql

This problem is so complicated and depend on MySQL Version.My problem was happened on MySQL 8.0.2. When I've config my.ini file on notepad and save it.I soleved following @jhersey29 solution https://stackoverflow.com/a/55519014/1764354 but little different approch.

my solution is restore my.ini file and edit config value via Option files on WorkBench Application. workBench Menu Example

Solution 14 - Mysql

Rename or delete the folder under, > C:\ProgramData\MySQL\MySQL Server 5.7

folder name change as per your MYSQL version number.

Solution 15 - Mysql

Search for services.msc and look up through your services that are running if there is a mysql service running already other than the one you want to run (it could be xampp or wamp) or another service (for example Skype) using the same port as mysql and stop the service so you can run your mysql service.

Solution 16 - Mysql

I had this issue after my database was working fine for long time. It turned out it was some data corruption.

In the error log I had:

2017-02-07T10:11:42.270567Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 44002250712 and the end 44002250240.
2017-02-07T10:11:42.270606Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-02-07T10:11:42.577436Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-02-07T10:11:42.577470Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-02-07T10:11:42.577484Z 0 [ERROR] Failed to initialize plugins.
2017-02-07T10:11:42.577488Z 0 [ERROR] Aborting

Then I had to delete the 2 ib_logfile* files, and it restarted again.

Solution 17 - Mysql

my.ini file should save as (Encoding) ANSI not UTF-8 or others files.

Solution 18 - Mysql

another instance of mysql like 5.6 or 8 run at the same time

and the 80 port was reserved

please > go to >> services>> stop all another instance >> disable them

in my case problem solved and service started as well

Solution 19 - Mysql

In my case, mysqld was starting and stopping with no error message. I needed to open command prompt using "Run as Administrator", and then run mysqld.

I am only doing this for temporary development. I would not recommend running MySQL as an administrator in any case.

This was the final step after the above troubleshooting.

Solution 20 - Mysql

The same problem happened with me also, nothing worked... I first deleted the service (in my case MySQL80 and MySQL) by command:

sc delete MySQL80
sc delete MySql

and then reinstalled MySQL. Mine was MySQL 8.0. And then everything was back to normal.

Solution 21 - Mysql

Delete or rename the 2 following files from "C:\ProgramData\MySQL\MySQL Server 5.7\Data": ib_logfile0 ib_logfile1

Solution 22 - Mysql

the MySQL service on local computer started and then stopped

This Error happen when you modified my.ini in C:\ProgramData\MySQL\MySQL Server 8.0\my.ini not correct.

You can search my.ini original configuration or checking yours to make sure everything is OK

Solution 23 - Mysql

If you came across this while installing WAMP64 on Windows 10. Check if data folder in MySQL folder is missing. My WAMP 3.2.3 version installation failed to create such a folder. So wamp icon was orange (1 of 2 services running).

A quick fix was to run this command from MySQL location.

C:\wamp64\bin\mysql\mysql5.7.31\bin\
mysqld --initialize-insecure

Solution 24 - Mysql

non of the above actually works so delete mysql,reinstall mysql,restore back if any...enjoy

Solution 25 - Mysql

I had the exact same message as displayed in the question. I have tried many suggestions with little luck. I was about to install WAMP (I'm on Windows) and was about to uninstall MySql 8.0 first, when I noticed a program included in the installation: 'MySQL Installer - Community' so I tried that. With this installer I set up a new connection, added password to root, added another user with password, set my choice of locations for all logs and ran the install. The result was that it now totally works.

Solution 26 - Mysql

Such a problem can very often come due to configuration errors.

Vivek Sethi mentioned 20th December 2012 that it is possible to get logging in the console by running the following command:

C:\Windows\system32>"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" --standalone --console

Right-clicking on my service in Windows 10, I recognized the --defaults-file= parameter, and with console logging I was able to see what was wrong in my configuration. In my case the path to datadir= and secure-file-priv= was wrong. I hope others can be empowered as well by being able to see logging details in the console. Good luck!

Solution 27 - Mysql

I have faced the same situation. I have changed the server-id=2 and when saved got this error. After a lot of research, I have found the solution. In windows after

> changing my.ini mysql configuration file, save the file as > ANSI rather than UTF-8

This has worked for me well.

Solution 28 - Mysql

make sure your data folder is fully empty before use command mysqld --initialize

Solution 29 - Mysql

Go to "C:\ProgramData\MySQL\MySQL Server 8.0\Data\[machine name].err" and check the last rows - it should tell you why it failed. In my case it was duplicated tablespace id between databases.

It looks like this:

2021-09-12T05:19:22.815152Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-09-12T05:19:22.818357Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.22) starting as process 30664
2021-09-12T05:19:22.866774Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-12T05:19:22.908983Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2021-09-12T05:19:22.911667Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 124 = ['db1\accounts.ibd', 'db2\accounts.ibd'] 
2021-09-12T05:19:22.915514Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2021-09-12T05:19:22.918627Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2021-09-12T05:19:22.927714Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-09-12T05:19:22.930912Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-09-12T05:19:22.934432Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.22)  MySQL Community Server - GPL.

Solution 30 - Mysql

Changing xampp folder's permission in windows to full control for 'authenticates user' fixed my problem.

Solution 31 - Mysql

This happened in my install when I added the parameter

audit-log = ON

On the my.ini file, add to remove it for it to work

Solution 32 - Mysql

mysqld --initialize

Run the above after the install command. Then try to start the service - that should work.

Solution 33 - Mysql

If you have changed data directory (the path to the database root in my.ini) to an external hard drive, make sure that the hard drive is connected.

Categories
Recommended Mysql Solutions
Recommended Service Solutions
Recommended Window Solutions

Previous Solution:

How to load a model from an HDF5 file in Keras?

PythonMachine LearningKerasData Science

Next Solution:

Connect to docker container as user other than root

DockerContainersRoot

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionKem BardlyView Question on Stackoverflow
Solution 1 - MysqlAlexaView Answer on Stackoverflow
Solution 2 - Mysqljhersey29View Answer on Stackoverflow
Solution 3 - MysqlWarwickView Answer on Stackoverflow
Solution 4 - MysqlHan XiongView Answer on Stackoverflow
Solution 5 - MysqlManinderpal SinghView Answer on Stackoverflow
Solution 6 - Mysqltom andersonView Answer on Stackoverflow
Solution 7 - MysqlZirkoViterView Answer on Stackoverflow
Solution 8 - MysqlWes HendersonView Answer on Stackoverflow
Solution 9 - MysqlPhuVu94View Answer on Stackoverflow
Solution 10 - MysqlAlex KhimichView Answer on Stackoverflow
Solution 11 - MysqlSrihari KaranthView Answer on Stackoverflow
Solution 12 - MysqlGerma VinsmokeView Answer on Stackoverflow
Solution 13 - MysqltleahaView Answer on Stackoverflow
Solution 14 - Mysqljohn sooraj xavierView Answer on Stackoverflow
Solution 15 - MysqlSimbarashe MupfururirwaView Answer on Stackoverflow
Solution 16 - MysqlArisView Answer on Stackoverflow
Solution 17 - Mysqluser5816728View Answer on Stackoverflow
Solution 18 - Mysqlsaber tabatabaee yazdiView Answer on Stackoverflow
Solution 19 - MysqlRobert AllurentView Answer on Stackoverflow
Solution 20 - MysqlDeepanshuView Answer on Stackoverflow
Solution 21 - MysqlWolfView Answer on Stackoverflow
Solution 22 - MysqlPhuVu94View Answer on Stackoverflow
Solution 23 - MysqlSMJView Answer on Stackoverflow
Solution 24 - MysqlPushkar ShrivastavaView Answer on Stackoverflow
Solution 25 - MysqlRob FarquharsonView Answer on Stackoverflow
Solution 26 - MysqlpekaawView Answer on Stackoverflow
Solution 27 - Mysqlr ReddyView Answer on Stackoverflow
Solution 28 - Mysqluser3709120View Answer on Stackoverflow
Solution 29 - MysqlQua285View Answer on Stackoverflow
Solution 30 - Mysqluser13960527View Answer on Stackoverflow
Solution 31 - MysqlRaul Lapeira HerreroView Answer on Stackoverflow
Solution 32 - MysqlPraSanVarView Answer on Stackoverflow
Solution 33 - MysqlEhsanView Answer on Stackoverflow