首页 > mysql启动失败

mysql启动失败

环境: mysql55 redhat5.7 

首先阐明,去年用arch时玩mariadb,用的很顺风顺水.... 但是今年在arch下我的mariadb也一直没安装成功,情况基本跟现在一样...之前没有填坑,现在必须弥补了...

安装完后,启动失败...但并不清楚问题出在哪儿....试了下mysqld -urooot登录,发现是这个错误:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)

这个sock文件是不存在的...

我尝试安全启动,但是还是错误,下面是找到的错误日志(/var/lib/mysql/test.err):

150702 15:51:47 [Warning] Using unique option prefix key_buffer instead of key_b
uffer_size is deprecated and will be removed in a future release. Please use the
 full name instead.
150702 15:51:47 [Note] /usr/libexec/mysqld (mysqld 5.5.44-log) starting as proce
ss 15474 ...
150702 15:51:47 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
150702 15:51:47 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
150702 15:51:47 InnoDB: The InnoDB memory heap is disabled
150702 15:51:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150702 15:51:47 InnoDB: Compressed tables use zlib 1.2.3
150702 15:51:47 InnoDB: Using Linux native AIO
150702 15:51:47 InnoDB: Initializing buffer pool, size = 128.0M
150702 15:51:47 InnoDB: Completed initialization of buffer pool
150702 15:51:47 InnoDB: highest supported file format is Barracuda.
150702 15:51:47  InnoDB: Waiting for the background threads to start
150702 15:51:48 InnoDB: 5.5.44 started; log sequence number 1595675
150702 15:51:48 [ERROR] /usr/libexec/mysqld: unknown option '--skip-locking'
150702 15:51:48 [ERROR] Aborting

150702 15:51:48  InnoDB: Starting shutdown...
150702 15:51:49  InnoDB: Shutdown completed; log sequence number 1595675
150702 15:51:49 [Note] /usr/libexec/mysqld: Shutdown complete

150702 15:51:49 mysqld_safe mysqld from pid file /var/lib/mysql/test.pid ended

其它地方的日志基本就没有有用的信息了(可能是我没找全)

看了错误日志,发现错误,按照提示执行命令,但是又出现这个结果...


根据错误日志,请检查你的my.cnf,应该是你现在的版本不支持 --skip-locking,应该可以使用 --skip-external-locking 替代。

https://forums.cpanel.net/threads/skip-locking-and-log_slow_queries-de...

【热门文章】
【热门文章】