Error Codes
Errors, Error Codes, and Common Problems information can be found here
The MySQL server tends to spit out errors from time to time, and these are common errors that one can usually solve fairly easily.
Using perror
This is a tool to explain error codes. Everytime the server spits out a system error, you can run it through perror from the command line, and get a reason as to why the server has found an error. For example, if the server spits out error 13, you run:perror 13
And it will return the fact that there was an OS error code, which translates to being Permission Denied. For more usage information, use the manual page (man perror) or visit it online in the manual, under the topic http://dev.mysql.com/doc/en/perror.html Explain error codes.
Error Messages
Error: Cannot create Windows service for MySql. Error: 0
If you run perror 0, it would seem that MySQL succeeded. However, on Windows, this is an error that occurs when you upgrade MySQL from time-to-time. Read Error: Cannot create Windows service for MySql. Error: 0 below
Error 2003 (HY000): Can't connect to MySQL server on 'hostname' (10060)
The client failed to make a connection to the server. In other words, no MySQL server responded to a connection attempt. Read Error: Cannot create Windows service for MySql. Error: 0 belowfor a troubleshooting guide.
Error: Cannot create Windows service for MySql. Error: 0
This error is one you will encounter on Windows when you reinstall or upgrade MySQL without first stopping and removing the existing MySQL service. It is a very common error state, as going by the forum and mailing list postings.
To solve this, Mike Hillyer has created Mike's Service Remover. Simply extract the tool and run it.