mysql启动失败

 蒋小宁蒋小羊 发布于 2022-11-04 07:12
环境: 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

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

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

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

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

    2022-11-12 01:51 回答
撰写答案
今天,你开发时遇到什么问题呢?
立即提问
热门标签
PHP1.CN | 中国最专业的PHP中文社区 | PNG素材下载 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有