ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

来源：互联网发布：linux重启进程命令编辑：程序博客网时间：2024/06/14 06:30

mysql启动报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'，于是，我先检查了下mysql的状态

重新启动也一直卡住不动

mysql的安全模式好像也没啥卵用

最后只能是找错误日志了，先找到mysql的配置文件

sudo find / -name my.cnf -print,我的是在/etc/mysql/my.cnf,找到log_error = /var/log/mysql/error.log

找到error.log文件，找到最新的错误，如下：

160529 22:16:27 InnoDB: Starting shutdown...

160529 22:16:28 InnoDB: Shutdown completed; log sequence number 1867837
160529 22:16:28 [Note] /usr/sbin/mysqld: Shutdown complete

160529 22:16:29 [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.
160529 22:16:29 [Note] Plugin 'FEDERATED' is disabled.
160529 22:16:29 InnoDB: The InnoDB memory heap is disabled
160529 22:16:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160529 22:16:29 InnoDB: Compressed tables use zlib 1.2.8
160529 22:16:29 InnoDB: Using Linux native AIO
160529 22:16:29 InnoDB: Initializing buffer pool, size = 128.0M
160529 22:16:29 InnoDB: Completed initialization of buffer pool
160529 22:16:29 InnoDB: highest supported file format is Barracuda.
160529 22:16:29 InnoDB: Waiting for the background threads to start
160529 22:16:30 InnoDB: 5.5.49 started; log sequence number 1867837
160529 22:16:30 [ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8'
160529 22:16:30 [ERROR] Aborting
160529 22:16:30 InnoDB: Starting shutdown...
160529 22:16:31 InnoDB: Shutdown completed; log sequence number 1867837

160529 22:16:31 [Note] /usr/sbin/mysqld: Shutdown complete

明显的，这个是我前天配置数据库时设置的编码格式，但是好像mysql不认识，先删除试下，重新启动mysql，可以了

0 0