Forum Stats

  • 3,768,658 Users
  • 2,252,827 Discussions
  • 7,874,676 Comments

Discussions

Error FAQs

Lenka Kasparova-Oracle
Lenka Kasparova-Oracle Member Posts: 21 Employee
edited May 26, 2015 7:29AM in MySQL Community Space

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.