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:
Starting it through the XAMPP control panel does not work either:
Can you help me to solve this?
Asked
Active
Viewed 2.7k times
0
-
1Your error message in the second link explains why your service is not able to start. Fix your path or try to reinstall the whole thing... – Svekke Jan 30 '17 at 09:06
-
http://stackoverflow.com/questions/23624234/how-to-change-the-path-of-mysql-services .. Go with this question answer. – Kumar Rakesh Jan 30 '17 at 09:07
-
I tried reinstalling whole. But could not run MYsql. – Prashanth RH Jan 30 '17 at 09:29
3 Answers
3
- Open windows services (Start->run ->Services.MSC)
- 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
- 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.
Tushar_G
- 300
- 1
- 9
-
I found path C:\Program Files (x86)\MySQL\MySQL Server 5.5 here MySQL Server 5.5 folder didn't exist at all... – Prashanth RH Jan 30 '17 at 09:35
-
-
Its not only the path. But ports also were conflicting. I resolved. Thank-you.... – Prashanth RH Jan 30 '17 at 10:19
-
Thanks for this answer very very much. It helped me see that the path to MySQL service executable does not exist. I wonder why so but I will just uninstall the MySQL service and re-initialize the data directory with the --base-dir=path option set and re-install the service That should solve my case. Thanks again! – Michael Iyke Oct 12 '19 at 14:33
2
- Go to the path: C:Programs Files\MariaDB 10.2\data..
- Lookout for my.ini file. Open the file and check the path for "datadir".
- If that does not match to your installed directory then update it.
- Your problem will be solved for sure.
user944105
- 21
- 1
-
The path was C:\ProgramData\MySQL\MySQL Server 8.0 on my computer instead, but the fix worked so thank you. – user3452643 May 04 '23 at 17:51
