Follow this Blog!

Jun 8, 2010

f Comment

How do I Solve Errors of Starting MySQL on Windows?

Amazon I installed MySQL server on my Windows PC but mysqld.exe in the bin directory won't start. What should I do?

Solution
First of all you can install MySQL server as a Windows service so that it starts up automatically when you reboot. However let's assume this is not the case and you'd like to run MySQL manually by clicking on its executable the good old Windows way.

The following solution applies to MySQL version 14.7 Distrib 4.1.21 for Win32, and it may apply to your version as well.
If you've installed MySQL on Windows 7 Home Premium Edition but when you execute mysqld.exe to start MySQL server daemon in vain (the command returns immediately when you run it in a terminal or a window pops up and closes immediately if you double click mysqld.exe) try the following:

1. Make sure you are in the right directory: Your default location should be [root]\mysql\bin

2. Check your error log at \mysql\data\[computer-name].err

If none of the above helps you might have installed MySQL as a windows service but have not configured for it to run upon reboot.

In that case go to Start -> Run... -> Type "msconfig" -> Services. Then check the checkbox corresponding to "MySQL" Service. Restart your computer.

Once your computer has been restarted go to Windows Task Manager (right click anywhere in the windows toolbar and pick Task Manager) and in Processes tab see if you see mysqld.exe or mysqld-nt.exe running!

Questions?

Hope it helps
Please leave a comment here!
One Minute Information - by Michael Wen
Find Michael on Google or Facebook
ADVERTISING WITH US - Direct your advertising requests to Michael