Category: FAQ

ErrorFAQ


The MySQL server tends to spit out errors from time to time, and these are common errors that one can usually solve fairly easily.

Contents

[edit] 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 Explain error codes.

[edit] Error Messages

[edit] 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 Error0-CannotCreateWindowsServiceForMySQL

[edit] 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 Error2003-CantConnectToMySQLServer for a troubleshooting guide.

Retrieved from "http://forge.mysql.com/wiki/ErrorFAQ"

This page has been accessed 12,523 times. This page was last modified 22:05, 24 January 2011.

Find

Browse
MySQLForge
Main Page
Current events
Recent changes
Random page
Help
Edit
Edit this page
Editing help
This page
Discuss this page
Post a comment
Printable version
Context
Page history
What links here
Related changes
My pages
Special pages
New pages
File list
Statistics
Bug reports
More...