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

User · Answer

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.

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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 amp 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

User · Answer

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

[mysql] Mysql service is missing

Examples related to mysql

Examples related to service