Mysql service is missing

Question

I have installed Mysql server locally and everything was working Ok but today when I tried to get a connection to the local db, I got an error. After checking services showed that the MySql service is missing...

What can the problem be?

Thanks in advance for any helps

Maybe just mysql service is not running ? Have you started it ? — hsz, Apr 15 '11 at 15:50
this service was auto started each time i log into windows but now the service is absent from services list — Igal, Apr 15 '11 at 15:52

score 81 · Accepted Answer · answered Aug 21 '13 at 13:39

81

I have done it by the following way

Start cmd
Go to the "C:\Program Files\MySQL\MySQL Server 5.6\bin"
type mysqld --install

Like the following image. See for more information.

enter image description here

answered Aug 21 '13 at 13:39

Atish Dipongkor

9,710
8
47
76

2

Install/Remove of the service Denied! – 3xCh1_23 Apr 29 '16 at 15:24
10

The post is quite old, but you just had to open it as an Administrator. – David Peicho Jun 07 '16 at 19:08
1

Open cmd with Administrator rights to avoid "Install/Remove of the service Denied!" error – backslashN Apr 19 '17 at 13:17
2

Kind of bull crap that they don't mention this in the README file – Kellen Stuart Sep 13 '17 at 16:45

score 3 · Answer 2 · answered Feb 21 '15 at 05:43

I also face the same problem. do the simple steps

Go to bin directory copy the path and set it as a environment variable.
Run the command prompt as admin and cd to bin directory:
Run command : mysqld –install
Now the services are successfully installed
Start the service in service windows of os
Type mysql and go

NickSoft · Answer 3 · 2014-06-09T09:10:50.980

3

Go to your mysql bin directory and install mysql service again:

c:
cd \mysql\bin
mysqld-nt.exe --install

or if mysqld-nt.exe is missing (depending on version):

mysqld.exe --install

Then go to services, start the service and set it to automatic start.

edited Jun 09 '14 at 09:10

answered Apr 17 '11 at 15:53

NickSoft

2,945
5
24
45

1

i've found the problem. the service has disappeared after i've installed new CCleaner ver see here : – Igal Apr 17 '11 at 21:49
3

Just wanted to point out that on Windows you might have to disable UAC or run CMD as an administrator for this to work (I had to do the latter for it to work) other wise you get a message that states "Install/Remove of the service is denied" - more info here http://forums.mysql.com/read.php?11,497008,498205#msg-498205 – Sean Aug 05 '13 at 09:29

Jappie Kerk · Answer 4 · 2019-07-05T10:13:19.070

If you wish to have your config file on a different path you have to give your service a name:

mysqld --install NAME --defaults-file=C:\my-opts2.cnf

You can also use the name to install multiple mysql services listening on different sockets if you need that for some reason. You can see why it's failing by copying the execution path and adding --console to the end in the terminal. Finally, you can modify the starting path of a service by regediting:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\NAME

That works well but it isn't as useful because the windows service mechanism provides little logging capabilities.

score 1 · Answer 5 · edited Apr 23 '18 at 18:05

I came across the same problem. I properly installed the MYSQL Workbench 6.x, but faced the connection as below:

I did a bit R&D on this and found that MySQL service in service.msc is not present. To achieve this I created a new connection in MySQL Workbench then manually configured the MySQL Database Server in "System Profile" (see the below picture).

You also need to install MySQL Database Server and set a configuration file path for my.ini. Now at last test the connection (make sure MySQL service is running in services.msc).

score 0 · Answer 6 · answered Jan 04 '17 at 05:31

0

Go to

C:\Program Files\MySQL\MySQL Server 5.2\bin

then Open MySQLInstanceConfig file

then complete the wizard.

Click finish

Solve the problem

I think this is the best way to change the port number also.

It works for me

answered Jan 04 '17 at 05:31

Vighnu

11

Mysql service is missing

6 Answers6

Linked