Unable to start MySQL server

Question

Running Windows 7 64-bit.

I've been unable to start an instance of MySQL 5.6 server. When I attempt to start it from within the MySQL workbench, I get this:

2013-11-23 14:05:07 - Checking service status of instance MySQL...
2013-11-23 14:05:07 - Status check of service 'MySQL' returned stopped

I've tried manually starting the Windows service. Following advice that worked for others with the same problem, I've configured the service to log on as "Local System account". No dice; it throws this:

error 1053: the service did not respond to the start or control request in a timely fashion

I've also tried disabling my firewall, and completely reinstalling MySQL server.

It should perhaps be noted that (I assume as a result of all this) I also cannot log into the MySQL command line client. It tells me:

Can't connect to MySQL server on 'localhost' (10061)

This is my first time trying to set up a MySQL server, so perhaps there's just something I've missed. If so, I'm unsure what it is.

I debugged the problem by first trying to run an instance in command line (using bash or cmd.exe) to see the error logs (for some reason, the `.err` file didn't contain those errors, and when starting the service from windows service, it just says "automatically stopped..."). To find what command to run, find the entry in `ImagePath` variable in registry key `Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\`. This debugging exposed problems when I was tinkering with the `.ini` file but regarding actual issue, YMMV — gawkface, Sep 29 '22 at 07:10

score 29 · Answer 1 · answered Apr 22 '15 at 12:13

29

I had the same issue. Try this, it should work!

Right click on MySQL Notifier -> Actions -> Manage Monitored Items
Highlight the MySQL56 entry and click the delete button
Click the add button -> windows service
Scroll down and look for MySQL56
Highlight it and click ok

answered Apr 22 '15 at 12:13

Besan Vadim

441
4
8

it worked! was wondering what went wrong, but I guess some installations are not properly done – GChamon Nov 09 '15 at 21:34

score 10 · Answer 2 · answered Nov 23 '13 at 19:43

10

Try manually start the service from Windows services, Start -> cmd.exe -> services.msc. Also try to configure the MySQL server to run on another port and try starting it again. Change the my.ini file to change the port number.

answered Nov 23 '13 at 19:43

Aakash

1,860
19
30

1

Neither of these fixed the issue. It should be noted that the my.ini includes this comment: # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. I tried uncommenting the port line and designating a port. Would there be a different copy in the "default location"? If so, where might this be? I would expect this only to be copied if I was successfully able to set up the server. – The_Unobsequious Nov 23 '13 at 19:51
Check this, it specifies the locations for files...http://dev.mysql.com/doc/refman/5.1/en/option-files.html, by default the name would be my-default.ini. – Aakash Nov 23 '13 at 19:57
1

Also had my-default.ini. Tried changing it as well--did not fix. The reason I had both is because the MySQL command line client wouldn't even launch without my.ini, so I copied my-default.ini and renamed it, which allowed the client to launch. – The_Unobsequious Nov 23 '13 at 20:02
Try to do this using the Instance Configuration Wizard. It will recreate the ini file with the config that you specify. – Aakash Nov 23 '13 at 20:24
You can check if the port is being used or not [see this answer](https://stackoverflow.com/a/23718720/318807) – AJ Dhaliwal May 16 '19 at 10:58

score 8 · Answer 3 · edited Jan 08 '19 at 07:29

8

I had faced the same problem a few days ago.

I found the solution.

control panel
open administrative tool
services
find mysql80
start the service

also, check the username and password.

edited Jan 08 '19 at 07:29

rimonmostafiz

1,341
1
15
33

answered Jan 08 '19 at 06:17

dhaivat joshi

91
1
1

score 6 · Answer 4 · answered Jul 06 '14 at 08:41

You should start by checking the error log and/or the startup message log when managing the instance using MySQL Workbench. There could be clues as to what is going wrong, which may be different than this scenario.

When I had this issue, it was because I used a space in the service name during installation. While it is technically valid, you should not do that. It seems that the MySQL Installer (and MySQL Notifier) does not put the name in quotes which causes it to use an incorrect service name later on. There are two ways to fix the problem (all commands should be run from an elevated command prompt).

Reinstall the server

The first is to simply reinstall MySQL Server 5.6 using the default, no-space service name MySQL56.

The installer uses the same value for the service name and service display name. The name that I had originally specified was for a display name, when it should have been a simple service name. After installation, if you so choose, the display name can safely be changed to use spaces and other characters by using:

sc config MySQL56 DisplayName= "MySQL 5.6"

Recreate the service

If you don't want to reinstall the server however, you will have to recreate the service. Start by removing the old service:

mysqld --remove "service_name"

Now install the replacement. You can use --install to create a service that starts with the system automatically, or --install-manual to create a service that requires you to start it.

mysqld --install-manual "service_name" --local-service --defaults-file="C:\path\to\mysql\my.ini"

This creates a service that runs as the LocalService account which presents anonymous credentials on the network however. Under most circumstances this is fine, but if you want to use the NetworkService account (which is what the installer creates the service as) you can change it using the Services administrative tool.

I had to combine this answer with [this answer](https://stackoverflow.com/a/38960953/7032856). In order to have the service up and running. — Nae, May 19 '20 at 21:29

score 3 · Answer 5 · answered Aug 25 '18 at 18:45

3

Go to MySQL installer and click Reconfigure (don't change any existing settings). This should start the server and you'll be off.

answered Aug 25 '18 at 18:45

MemeyMcMemeFace

31
1

score 1 · Answer 6 · edited Jun 24 '15 at 15:10

Keep dump/backup of all databases.This is not 100% reliable process. Manual backup: Go to datadir path (see in my.ini file) and copy all databases.sql files from data folder

This error will be thrown when unexpectedly MySql service is stopped or disabled and not able to restart in the Services.

First try restart PC and MySql Service couple of times ,if still getting same error then follow the steps.

Keep open the following wizards and folders:

C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin
C:\Program Files (x86)\MySQL\MySQL Server 5.5

Services list ->select MySql Service.

Go to installed folder MySql, double-click on instance config C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\MySqlInstanceConfig.exe

Then select remove instance and click on next to remove non-working MySql service instance. See in the Service list (refresh F5) where MySql service should not be found.

Now go to C:\Program Files (x86)\MySQL\MySQL Server 5.5 open my.ini file check below

#Path to installation directory

basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.5/"

#Path to data directory

datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"

Choose data dir Go to "C:/ProgramData/MySQL/MySQL Server 5.5/Data/" It contains all tables data and log info, ib data, user.err,user.pid . Delete
- log files,
- ib data,
- user.err,
- user.pid files.

(why because to create new MySql instance or when reconfiguring MySql service by clicking on MySqlInstanceConfig.exe and selecting default configure, after enter choosing password and clicking on execute the wizard will try to create these log files or will try to append the text again to these log files and other files which will make the setup wizard as unresponding and finally end up with configuration not done).

After deleted selected files from C:/ProgramData/MySQL/MySQL Server 5.5/Data/ go to C:\Program Files (x86)\MySQL\MySQL Server 5.5

Delete the selected files my.ini and and other .bak format files which cause for the instance config.exe un-responding.

C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\MySqlInstanceConfig.exe Select MySqlInstanceConfig.exe and double-click on it and select default configuration or do the regular set up that we do when installing MySql server first time.

Perfect Answer . Thanks you saved me @user2551594 – Jay Prakash Dec 20 '16 at 04:45 — Jay Prakash, Dec 20 '16 at 04:45

sgirardin · Answer 7 · 2017-03-26T14:09:29.307

If like me you had installed a MySQL on your server (Windows 2012), and when reinstalling the installer is unable to start the MySQL service. Then you have to completely erase MySQL! I had to do the following steps to be sure :

Uninstall MySQL like any any software through the Control Panel -> Uninstall a Program
Be sure to erase the MySQL folder where you installed it.
Here is the trick (at least for me), you have to erase the C:\ProgramData\MySQL directory. Even if's not visible through the User Interface, enter the address in the windows explorer and you will find it! You will lose all the previous databases and users.
Restart your OS
When restarted check if the MySQL service is no more present the Windows Services (search for services in windows).
Be sure no services that use MySQL (application needing access to MySQL) are active
Resinstall MySQL and the service will be able to install itself again.

Got my info from the following blog :http://blogs.iis.net/rickbarber/completely-uninstall-mysql-from-windows

score 0 · Answer 8 · answered Dec 20 '16 at 09:14

0

Mine did not start because the Server did not accept the 'Dedicated MySQL Server' setting in the Configuration.

answered Dec 20 '16 at 09:14

Wandile Nxumalo

15
7

1

This should be a comment – ρяσѕρєя K Dec 20 '16 at 09:41
Specifically, as @Matt's answer states, the service name cannot contain a space. This issue still exists today, and apparently has been an unaddressed problem for six years. – bindsniper001 Apr 01 '20 at 04:21

score 0 · Answer 9 · answered Nov 09 '17 at 19:38

0

See this post https://bugs.mysql.com/bug.php?id=67917 Sometimes a temp directory is missing. I had the same error like "InnoDB: Error: unable to create temporary file; errno: 2"

answered Nov 09 '17 at 19:38

Fridtjof Koene

1

1

Please add contextual information rather than just providing a link. Links can disappear making your answer less useful. – user3486184 Nov 09 '17 at 19:59

score 0 · Answer 10 · answered Dec 13 '17 at 05:37

0

I solved it by open a command prompt as an administrator and point to mysql folder -> bin -> mysql.exe. it works

answered Dec 13 '17 at 05:37

Poorna

191
1
5

score 0 · Answer 11 · answered Aug 31 '20 at 08:20

In my case I had to go to the MySQL installer, then configuration button for the MySQL server, then next until the option to "create the server as a windows service" ticked that, gave it a service name as MySQL8.0, next and then finish, that solved the issue and started a new service

score 0 · Answer 12 · answered Feb 02 '21 at 14:38

In my case, I went for

MySQL install Uninstall only the MySQL Server Install again

Make sure the Path is the same for example (if your installer warns you of a conflict): C:\Program Files...etc... C:\Program Files...etc...

If they are the same, it should work fine.

User · Answer 13 · 2021-04-20T04:27:55.923

0

Go to services and check whether the MySql is there. If not

    Start cmd in administrator mode
    Go to the "C:\Program Files\MySQL\MySQL Server X.X\bin"
    type mysqld --install

You may need to execute mysqld --initialize as well.

then start MySql in service window.

edited Apr 20 '21 at 04:27

answered Apr 20 '21 at 04:22

User

1,460
14
11

score 0 · Answer 14 · answered May 19 '21 at 06:03

On my windows 10,

Stop the configuration
locate my.ini from C:\ProgramData\MySQL\MySQL Server 8.0\ and uncomment from the 'basedir' from the following:

Path to installation directory. All paths are usually resolved relative to this.

basedir="C:/Program Files/MySQL/MySQL Server 8.0/"

Rerun the installation again.

Worked for me.

score 0 · Answer 15 · answered Nov 01 '21 at 03:12

0

i had the same mysql issue try to change the port and then restart xampp server if issue is not sloved then restart your PC that sloved my issue

answered Nov 01 '21 at 03:12

Karishma

17
7

score 0 · Answer 16 · answered Jul 15 '22 at 06:40

While not the most straightforward method, I was able to resolve this issue by:

Attempting to upgrade MySQL Server via the MySQL Community Installer, which failed and gave me this error message: Multiple files found for the same tablespace ID: Tablespace ID: 948 = ['database1\table1.ibd', 'database2\table2.ibd']
Navigating to my data folder and deleting one of the two databases that had the duplicate tablespace ID (after taking a backup).

I'm not sure how the issue arose to begin with, but after deleting the file, the MySQL service went back to launching without any issues.

score 0 · Answer 17 · answered Mar 19 '23 at 14:23

0

Open MySQL workbench -> Open an instance -> Click on Server [in the top ribbon] -> Startup/Shutdown ->Click on start server

This worked for me

answered Mar 19 '23 at 14:23

Pavan Bashetty

11
3

score -1 · Answer 18 · answered Mar 09 '22 at 11:14

-1

in my case, mysql unable to start and running is because you have more than one software apache. so you have to stop you apache2 with this code:

`sudo service apache2 stop `

when you already stop apache2, you can run again you mysql. hopefully it will help you

answered Mar 09 '22 at 11:14

ahm

107
2
9

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Mar 09 '22 at 12:33

Unable to start MySQL server

18 Answers18

Reinstall the server

Recreate the service

Path to installation directory. All paths are usually resolved relative to this.