DB :: ERROR 2002(HY000): Can't connect to local MYSQL server through socket '/var/lib/mysql/mysql.sock'(2) 오류 해결법

DB :: ERROR 2002(HY000): Can't connect to local MYSQL server through socket '/var/lib/mysql/mysql.sock'(2) 오류 해결법

다음과 같은 오류가 발생했을 때 mysql error.log를 확인합니다.

error.log를 확인했더니, 다음과 같은 글들이 작성되네영.

150118  0:12:37  InnoDB: Starting shutdown... 150118  0:12:38  InnoDB: Shutdown completed; log sequence number 3703526 150118  0:12:38 [Note] /usr/sbin/mysqld: Shutdown complete 150118  0:12:38 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 150118  0:12:38 [Note] Plugin 'FEDERATED' is disabled. 150118  0:12:38 InnoDB: The InnoDB memory heap is disabled 150118  0:12:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150118  0:12:38 InnoDB: Compressed tables use zlib 1.2.8 150118  0:12:38 InnoDB: Using Linux native AIO 150118  0:12:38 InnoDB: Initializing buffer pool, size = 128.0M 150118  0:12:38 InnoDB: Completed initialization of buffer pool 150118  0:12:38 InnoDB: highest supported file format is Barracuda. 150118  0:12:38  InnoDB: Waiting for the background threads to start 150118  0:12:39 InnoDB: 5.5.40 started; log sequence number 3703526 150118  0:12:39 [ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8' 150118  0:12:39 [ERROR] Aborting

error.log 확인하고 default-character-set=utf8이 문제네요,

my.cnf에 들어가서 관련 문자가 써져있는 것을 전부 주석처리나 삭제해주시고

mysql을 restart 합니다.