CODEWITHSUNDEEP
mysqlxampp
Prashanth RH
Prashanth RH

Reputation: 43

windows could not start the MySQL. service on local computer. Error 2 : The system cannot find the file specified

I am not able to start the MySQL server on my Windows system. When I tried in services.msc to run, I got this error:

Screenshot

Starting it through the XAMPP control panel does not work either:

Screenshot

Can you help me to solve this?

Upvotes: 0

Views: 32177

Answers (3)

Jackson90
Jackson90

Reputation: 11

I faced the same problem and solved it.

Just modify the registry editor value.

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/MySQL/ImagePath

enter image description here

Upvotes: 1

user944105
user944105

Reputation: 31

  1. Go to the path: C:Programs Files\MariaDB 10.2\data..
  2. Lookout for my.ini file. Open the file and check the path for "datadir".
  3. If that does not match to your installed directory then update it.
  4. Your problem will be solved for sure.

Upvotes: 3

Tushar_G
Tushar_G

Reputation: 300

  1. Open windows services (Start->run ->Services.MSC)
  2. Find service with name "Mysql Server" and check path, it should be something like that:

"C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\bin\mysqld.exe" "--defaults-file=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data\my.ini" MySQL

  1. Make sure that Mysql folder and executable file mentioned above exist by this path.

OR

Sometimes the file name of mysqld-nt.exe renamed to mysqld-nt.exe~ so rename it back to its original name and this may solve the problem.

Upvotes: 3

Related Questions