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
The default data directory location is C:\Program Files\MySQL\MySQL Server 8.0\data , or C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. The C:\ProgramData directory is hidden by default.
To download MySQL installer, go to the following link http://dev.mysql.com/downloads/installer/. There are two installer files: If you are connecting to the internet while installing MySQL, you can choose the online installation version mysql-installer-web-community-<version>.exe .
I have done it by the following way
Like the following image. See for more information.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With