MySQL Client Error Codes and Messages 2000 - 2049

1700 - 1749 2050 - 2099

Error: 2000 (CR_UNKNOWN_ERROR)

Message: Unknown MySQL error
Error: 2001 (CR_SOCKET_CREATE_ERROR)

Message: Can't create UNIX socket (%d)

```
Error: 2002 (CR_CONNECTION_ERROR)
Message: Can't connect to local MySQL server through socket '%s'
```
How does the MySQL error message look like?
```
shell> mysql --user=root --socket=/tmp/mysql.sock
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
```
What does the MySQL error message mean?

This MySQL error message means, that your MySQL Client utily cannot connect to the Server using the specified socket file.

More information you can find with the command:
```
shell> perror 2
OS error code   2:  No such file or directory
```
When does this MySQL error happen?

This MySQL error happens when your MySQL Server is not running (locally) or when the socket file is not at the location you have specified or where the default points to.

How to fix this MySQL error?

Try to find out if your MySQL Server is runnng on your local machine and if the socket file exists. Start the MySQL Server if it is not running or specify the path and the name of the socket file correctly.

Error: 2003 (CR_CONN_HOST_ERROR)

Message: Can't connect to MySQL server on '%s' (%d)
Error: 2004 (CR_IPSOCK_ERROR)

Message: Can't create TCP/IP socket (%d)
Error: 2005 (CR_UNKNOWN_HOST)

Message: Unknown MySQL server host '%s' (%d)

```
Error: 2006 (CR_SERVER_GONE_ERROR)
Message: MySQL server has gone away
```
How does the MySQL error message look like?
```
mysql> SELECT * FROM mysql.user LIMIT 1;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    6
Current database: *** NONE ***
```
What does the MySQL error message mean?

This means either that you connection has been killed, that the connection got lost or that the MySQL server died or was stopped.

When does this MySQL error message happen?
- Connection has been killed:
  You can see this for example with the following command:
```
mysql> SHOW GLOBAL STATUS LIKE 'Aborted_clients';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| Aborted_clients  | 1     |
+------------------+-------+
```
- When the MySQL Server crashed or was stopped it looks like this:
```
mysql> SELECT * FROM mysql.user LIMIT 1;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR: Can't connect to the server
```
  Then you have to look into the MySQL Server error log (typically at /var/lib/mysql/server.err). There it should be visible if the MySQL Server crashed or was stopped.
- Restore failed:
```
shell> mysql --user=root < full_dump
ERROR 2006 (HY000) at line 7776: MySQL server has gone away
```
  In this case possibly max_allowed_packet was too small.
How to fix this MySQL error?

When your session was killed or the MySQL Server was restarted or stopped, try to find out who killed your session and why. When the MySQL Server was crashed restart it and investigate more why it was crashed. The MySQL error log and the MySQL Bugs database very often tells you why.

Error: 2007 (CR_VERSION_ERROR)

Message: Protocol mismatch; server version = %d, client version = %d
Error: 2008 (CR_OUT_OF_MEMORY)

Message: MySQL client ran out of memory
Error: 2009 (CR_WRONG_HOST_INFO)

Message: Wrong host info
Error: 2010 (CR_LOCALHOST_CONNECTION)

Message: Localhost via UNIX socket
Error: 2011 (CR_TCP_CONNECTION)

Message: %s via TCP/IP
Error: 2012 (CR_SERVER_HANDSHAKE_ERR)

Message: Error in server handshake
Error: 2013 (CR_SERVER_LOST)

Message: Lost connection to MySQL server during query
Error: 2014 (CR_COMMANDS_OUT_OF_SYNC)

Message: Commands out of sync; you can't run this command now
Error: 2015 (CR_NAMEDPIPE_CONNECTION)

Message: Named pipe: %s
Error: 2016 (CR_NAMEDPIPEWAIT_ERROR)

Message: Can't wait for named pipe to host: %s pipe: %s (%lu)
Error: 2017 (CR_NAMEDPIPEOPEN_ERROR)

Message: Can't open named pipe to host: %s pipe: %s (%lu)
Error: 2018 (CR_NAMEDPIPESETSTATE_ERROR)

Message: Can't set state of named pipe to host: %s pipe: %s (%lu)
Error: 2019 (CR_CANT_READ_CHARSET)

Message: Can't initialize character set %s (path: %s)
Error: 2020 (CR_NET_PACKET_TOO_LARGE)

Message: Got packet bigger than 'max_allowed_packet' bytes
Error: 2021 (CR_EMBEDDED_CONNECTION)

Message: Embedded server
Error: 2022 (CR_PROBE_SLAVE_STATUS)

Message: Error on SHOW SLAVE STATUS:
Error: 2023 (CR_PROBE_SLAVE_HOSTS)

Message: Error on SHOW SLAVE HOSTS:
Error: 2024 (CR_PROBE_SLAVE_CONNECT)

Message: Error connecting to slave:
Error: 2025 (CR_PROBE_MASTER_CONNECT)

Message: Error connecting to master:
Error: 2026 (CR_SSL_CONNECTION_ERROR)

Message: SSL connection error
Error: 2027 (CR_MALFORMED_PACKET)

Message: Malformed packet
Error: 2028 (CR_WRONG_LICENSE)

Message: This client library is licensed only for use with MySQL servers having '%s' license
Error: 2029 (CR_NULL_POINTER)

Message: Invalid use of null pointer
Error: 2030 (CR_NO_PREPARE_STMT)

Message: Statement not prepared
Error: 2031 (CR_PARAMS_NOT_BOUND)

Message: No data supplied for parameters in prepared statement
Error: 2032 (CR_DATA_TRUNCATED)

Message: Data truncated
Error: 2033 (CR_NO_PARAMETERS_EXISTS)

Message: No parameters exist in the statement
Error: 2034 (CR_INVALID_PARAMETER_NO)

Message: Invalid parameter number
Error: 2035 (CR_INVALID_BUFFER_USE)

Message: Can't send long data for non-string/non-binary data types (parameter: %d)
Error: 2036 (CR_UNSUPPORTED_PARAM_TYPE)

Message: Using unsupported buffer type: %d (parameter: %d)
Error: 2037 (CR_SHARED_MEMORY_CONNECTION)

Message: Shared memory: %s
Error: 2038 (CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR)

Message: Can't open shared memory; client could not create request event (%lu)
Error: 2039 (CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR)

Message: Can't open shared memory; no answer event received from server (%lu)
Error: 2040 (CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR)

Message: Can't open shared memory; server could not allocate file mapping (%lu)
Error: 2041 (CR_SHARED_MEMORY_CONNECT_MAP_ERROR)

Message: Can't open shared memory; server could not get pointer to file mapping (%lu)
Error: 2042 (CR_SHARED_MEMORY_FILE_MAP_ERROR)

Message: Can't open shared memory; client could not allocate file mapping (%lu)
Error: 2043 (CR_SHARED_MEMORY_MAP_ERROR)

Message: Can't open shared memory; client could not get pointer to file mapping (%lu)
Error: 2044 (CR_SHARED_MEMORY_EVENT_ERROR)

Message: Can't open shared memory; client could not create %s event (%lu)
Error: 2045 (CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR)

Message: Can't open shared memory; no answer from server (%lu)
Error: 2046 (CR_SHARED_MEMORY_CONNECT_SET_ERROR)

Message: Can't open shared memory; cannot send request event to server (%lu)
Error: 2047 (CR_CONN_UNKNOW_PROTOCOL)

Message: Wrong or unknown protocol
Error: 2048 (CR_INVALID_CONN_HANDLE)

Message: Invalid connection handle
Error: 2049 (CR_SECURE_AUTH)

Message: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)