Error code
MySQL 2002
MYSQL2002
Database Error Code· An error code returned by a database server such as PostgreSQL or MySQL.
What it means
Can't connect to local MySQL server through socket — the socket file is missing.
How to fix it
- Start the MySQL service with systemctl start mysql or service mysql start.
- Verify the socket path in my.cnf matches the path specified in the connection string.
- Use TCP/IP (--host=127.0.0.1) instead of a socket connection as a temporary workaround.
Not affiliated with MySQL. Answer summarized from the manufacturer's manual linked above; consult that source for the authoritative procedure.
More MySQL codes
- 2003Can't connect to MySQL server on host — connection refused or host unreachable
- 2006MySQL server has gone away — the server closed the connection mid-query
- 1040Too many connections — the server has reached its connection limit
- 1044Access denied for user to database — missing GRANT
- 1045Access denied for user — wrong credentials
- 1048Column cannot be null — a required column received a NULL
- 1050Table already exists — CREATE TABLE failed because the name is taken
- 1051Unknown table — a DROP or query referenced a table that does not exist
- 1054Unknown column — the column name is not defined on the table
- 1062Duplicate entry for key — unique constraint violated
- 1064SQL syntax error — the query contains invalid SQL
- 1136Column count does not match value count — INSERT column and value lists differ