mysql启动失败

Question

环境： 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

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

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

Answer 1

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

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