Error No. Error Code Error Message or Condition Notes
--- None Password fails when entered on the command line http://dev.mysql.com/doc/refman/5.1/en/password-too-long.html
2000 CR_UNKNOWN_ERROR Unknown MySQL error
2001 CR_SOCKET_CREATE_ERROR Can't create UNIX socket (#)
2002 CR_CONNECTION_ERROR Can't connect to local MySQL server through socket 'str' (#) http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
2003 CR_CONN_HOST_ERROR Can't connect to MySQL server on 'str' (#) http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
2004 CR_IPSOCK_ERROR Can't create TCP/IP socket (#)
2005 CR_UNKNOWN_HOST Unknown MySQL server host 'str' (#)
2006 CR_SERVER_GONE_ERROR MySQL server has gone away http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
2007 CR_VERSION_ERROR Protocol mismatch; server version = #, client version = #
2008 CR_OUT_OF_MEMORY MySQL client ran out of memory
2009 CR_WRONG_HOST_INFO Wrong host info
2010 CR_LOCALHOST_CONNECTION Localhost via UNIX socket
2011 CR_TCP_CONNECTION str via TCP/IP
2012 CR_SERVER_HANDSHAKE_ERR Error in server handshake
2013 CR_SERVER_LOST Lost connection to MySQL server during query http://dev.mysql.com/doc/refman/5.5/en/error-lost-connection.html
2014 CR_COMMANDS_OUT_OF_SYNC Commands out of sync; you can't run this command now http://dev.mysql.com/doc/refman/5.1/en/commands-out-of-sync.html
2015 CR_NAMEDPIPE_CONNECTION Named pipe: str
2016 CR_NAMEDPIPEWAIT_ERROR Can't wait for named pipe to host: str pipe: str (%lu)
2017 CR_NAMEDPIPEOPEN_ERROR Can't open named pipe to host: str pipe: str (%lu)
2018 CR_NAMEDPIPESETSTATE_ERROR Can't set state of named pipe to host: str pipe: str (%lu)
2019 CR_CANT_READ_CHARSET Can't initialize character set str (path: str) http://dev.mysql.com/doc/refman/5.5/en/cannot-initialize-character-set.html
2020 CR_NET_PACKET_TOO_LARGE Got packet bigger than 'max_allowed_packet' bytes http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html
2021 CR_EMBEDDED_CONNECTION Embedded server
2022 CR_PROBE_SLAVE_STATUS Error on SHOW SLAVE STATUS:
2023 CR_PROBE_SLAVE_HOSTS Error on SHOW SLAVE HOSTS:
2024 CR_PROBE_SLAVE_CONNECT Error connecting to slave:
2025 CR_PROBE_MASTER_CONNECT Error connecting to master:
2026 CR_SSL_CONNECTION_ERROR SSL connection error
2027 CR_MALFORMED_PACKET Malformed packet
2028 CR_WRONG_LICENSE This client library is licensed only for use with MySQL servers having 'str' license
2029 CR_NULL_POINTER Invalid use of null pointer
2030 CR_NO_PREPARE_STMT Statement not prepared
2031 CR_PARAMS_NOT_BOUND No data supplied for parameters in prepared statement
2032 CR_DATA_TRUNCATED Data truncated
2033 CR_NO_PARAMETERS_EXISTS No parameters exist in the statement
2034 CR_INVALID_PARAMETER_NO Invalid parameter number
2035 CR_INVALID_BUFFER_USE Can't send long data for non-string/non-binary data types (parameter: #)
2036 CR_UNSUPPORTED_PARAM_TYPE Using unsupported buffer type: # (parameter: #)
2037 CR_SHARED_MEMORY_CONNECTION Shared memory: str
2038 CR_SHARED_MEMORY_CONNECT_REQUEST Can't open shared memory; client could not create request event (%lu)
2039 CR_SHARED_MEMORY_CONNECT_ANSWER_ Can't open shared memory; no answer event received from server (%lu)
2040 CR_SHARED_MEMORY_CONNECT_FILE_MA Can't open shared memory; server could not allocate file mapping (%lu)
2041 CR_SHARED_MEMORY_CONNECT_MAP_ERR Can't open shared memory; server could not get pointer to file mapping (%lu)
2042 CR_SHARED_MEMORY_FILE_MAP_ERROR Can't open shared memory; client could not allocate file mapping (%lu)
2043 CR_SHARED_MEMORY_MAP_ERROR Can't open shared memory; client could not get pointer to file mapping (%lu)
2044 CR_SHARED_MEMORY_EVENT_ERROR Can't open shared memory; client could not create str event (%lu)
2045 CR_SHARED_MEMORY_CONNECT_ABANDON Can't open shared memory; no answer from server (%lu)
2046 CR_SHARED_MEMORY_CONNECT_SET_ERR Can't open shared memory; cannot send request event to server (%lu)
2047 CR_CONN_UNKNOW_PROTOCOL Wrong or unknown protocol
2048 CR_INVALID_CONN_HANDLE Invalid connection handle
2049 CR_SECURE_AUTH Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) http://dev.mysql.com/doc/refman/5.5/en/old-client.html
2050 CR_FETCH_CANCELED Row retrieval was canceled by mysql_stmt_close() call
2051 CR_NO_DATA Attempt to read column without prior row fetch
2052 CR_NO_STMT_METADATA Prepared statement contains no metadata
2053 CR_NO_RESULT_SET Attempt to read a row while there is no result set associated with the statement
2054 CR_NOT_IMPLEMENTED This feature is not implemented yet
2055 CR_SERVER_LOST_EXTENDED Lost connection to MySQL server at 'str', system #
2056 CR_STMT_CLOSED Statement closed indirectly because of a preceeding str() call
2057 CR_NEW_STMT_METADATA The number of columns in the result set differs from the number of bound buffers. You must reset the statement, rebind the result set columns, and execute the statement again
2058 CR_ALREADY_CONNECTED This handle is already connected. Use a separate handle for each connection.
--- None Password fails when entered on the command line http://dev.mysql.com/doc/refman/5.1/en/password-too-long.html
2000 CR_UNKNOWN_ERROR Unknown MySQL error
2001 CR_SOCKET_CREATE_ERROR Can't create UNIX socket (#)
2002 CR_CONNECTION_ERROR Can't connect to local MySQL server through socket 'str' (#) http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
2003 CR_CONN_HOST_ERROR Can't connect to MySQL server on 'str' (#) http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
2004 CR_IPSOCK_ERROR Can't create TCP/IP socket (#)
2005 CR_UNKNOWN_HOST Unknown MySQL server host 'str' (#)
2006 CR_SERVER_GONE_ERROR MySQL server has gone away http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
2007 CR_VERSION_ERROR Protocol mismatch; server version = #, client version = #
2008 CR_OUT_OF_MEMORY MySQL client ran out of memory
2009 CR_WRONG_HOST_INFO Wrong host info
2010 CR_LOCALHOST_CONNECTION Localhost via UNIX socket
2011 CR_TCP_CONNECTION str via TCP/IP
2012 CR_SERVER_HANDSHAKE_ERR Error in server handshake
2013 CR_SERVER_LOST Lost connection to MySQL server during query http://dev.mysql.com/doc/refman/5.5/en/error-lost-connection.html
2014 CR_COMMANDS_OUT_OF_SYNC Commands out of sync; you can't run this command now http://dev.mysql.com/doc/refman/5.1/en/commands-out-of-sync.html
2015 CR_NAMEDPIPE_CONNECTION Named pipe: str
2016 CR_NAMEDPIPEWAIT_ERROR Can't wait for named pipe to host: str pipe: str (%lu)
2017 CR_NAMEDPIPEOPEN_ERROR Can't open named pipe to host: str pipe: str (%lu)
2018 CR_NAMEDPIPESETSTATE_ERROR Can't set state of named pipe to host: str pipe: str (%lu)
2019 CR_CANT_READ_CHARSET Can't initialize character set str (path: str) http://dev.mysql.com/doc/refman/5.5/en/cannot-initialize-character-set.html
2020 CR_NET_PACKET_TOO_LARGE Got packet bigger than 'max_allowed_packet' bytes http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html
2021 CR_EMBEDDED_CONNECTION Embedded server
2022 CR_PROBE_SLAVE_STATUS Error on SHOW SLAVE STATUS:
2023 CR_PROBE_SLAVE_HOSTS Error on SHOW SLAVE HOSTS:
2024 CR_PROBE_SLAVE_CONNECT Error connecting to slave:
2025 CR_PROBE_MASTER_CONNECT Error connecting to master:
2026 CR_SSL_CONNECTION_ERROR SSL connection error
2027 CR_MALFORMED_PACKET Malformed packet
2028 CR_WRONG_LICENSE This client library is licensed only for use with MySQL servers having 'str' license
2029 CR_NULL_POINTER Invalid use of null pointer
2030 CR_NO_PREPARE_STMT Statement not prepared
2031 CR_PARAMS_NOT_BOUND No data supplied for parameters in prepared statement
2032 CR_DATA_TRUNCATED Data truncated
2033 CR_NO_PARAMETERS_EXISTS No parameters exist in the statement
2034 CR_INVALID_PARAMETER_NO Invalid parameter number
2035 CR_INVALID_BUFFER_USE Can't send long data for non-string/non-binary data types (parameter: #)
2036 CR_UNSUPPORTED_PARAM_TYPE Using unsupported buffer type: # (parameter: #)
2037 CR_SHARED_MEMORY_CONNECTION Shared memory: str
2038 CR_SHARED_MEMORY_CONNECT_REQUEST Can't open shared memory; client could not create request event (%lu)
2039 CR_SHARED_MEMORY_CONNECT_ANSWER_ Can't open shared memory; no answer event received from server (%lu)
2040 CR_SHARED_MEMORY_CONNECT_FILE_MA Can't open shared memory; server could not allocate file mapping (%lu)
2041 CR_SHARED_MEMORY_CONNECT_MAP_ERR Can't open shared memory; server could not get pointer to file mapping (%lu)
2042 CR_SHARED_MEMORY_FILE_MAP_ERROR Can't open shared memory; client could not allocate file mapping (%lu)
2043 CR_SHARED_MEMORY_MAP_ERROR Can't open shared memory; client could not get pointer to file mapping (%lu)
2044 CR_SHARED_MEMORY_EVENT_ERROR Can't open shared memory; client could not create str event (%lu)
2045 CR_SHARED_MEMORY_CONNECT_ABANDON Can't open shared memory; no answer from server (%lu)
2046 CR_SHARED_MEMORY_CONNECT_SET_ERR Can't open shared memory; cannot send request event to server (%lu)
2047 CR_CONN_UNKNOW_PROTOCOL Wrong or unknown protocol
2048 CR_INVALID_CONN_HANDLE Invalid connection handle
2049 CR_SECURE_AUTH Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) http://dev.mysql.com/doc/refman/5.5/en/old-client.html
2050 CR_FETCH_CANCELED Row retrieval was canceled by mysql_stmt_close() call
2051 CR_NO_DATA Attempt to read column without prior row fetch
2052 CR_NO_STMT_METADATA Prepared statement contains no metadata
2053 CR_NO_RESULT_SET Attempt to read a row while there is no result set associated with the statement
2054 CR_NOT_IMPLEMENTED This feature is not implemented yet
2055 CR_SERVER_LOST_EXTENDED Lost connection to MySQL server at 'str', system #
2056 CR_STMT_CLOSED Statement closed indirectly because of a preceeding str() call
2057 CR_NEW_STMT_METADATA The number of columns in the result set differs from the number of bound buffers. You must reset the statement, rebind the result set columns, and execute the statement again
2058 CR_ALREADY_CONNECTED This handle is already connected. Use a separate handle for each connection.
Nice articel, This article help me very well. Thank you. Also please check my article on my site Know All About Web Tutorial.
ReplyDelete