Centos7启动mysql5.6 提示ERROR! The server quit without updating PID file (/var/lib/mysql/XXX.pid).
来源:互联网 发布:数据库工程师认证考试 编辑:程序博客网 时间:2024/05/21 06:22
Centos7安装安装MySQL-server-5.6.35-1.el7.x86_64.rpm,提示安装失败,因为Centos7安装时默认安装mariadb-libs.XXXXXX.rpm,
需要卸载mariadb-libs.XXXXXX.rpm,才能安装,卸载mariadb-libs.XXXXXX.rpm
使用rpm -qa|grep -i mariadb-libs 搜索
然后rpm -e mariadb-libs-XXXXXX.x86_64 --nodeps进行强制卸载。
mysql安装需要的rpm包:
MySQL-client-5.6.35-1.el7.x86_64.rpm
MySQL-server-5.6.35-1.el7.x86_64.rpm
安装完毕后,通过 service mysql start 命令进行启动,mysql暂时不支持systemctl(centos7启动服务的命令),如果启动提示
[root@localhost etc]# service mysql start
Starting MySQL........ ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).
※※出现上述错误的原因说明Centos7系统中默认安装了一些有关mysql和mariadb的文件,此时在rpm安装的mysql默认的初始化数据库路径下是没有创建performance_schema文件夹的(mysql初始化数据库时会创建mysql、performance_schema、test三个文件夹的)。
解决办法
安装上述两个rpm安装包时,需要先将Centos7系统中的有关mysql和mariadb的文件进行删除
find / -name mysql
find / -name mariadb
查询将所有有关数据进行删除删除,卸载安装的mysql两个rpm包,重新安装即可。
- Centos7启动mysql5.6 提示ERROR! The server quit without updating PID file (/var/lib/mysql/XXX.pid).
- Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/obcit-test.pid).
- ERROR! The server quit without updating PID file (/var/lib/mysql/service.pid).
- ERROR! The server quit without updating PID file (/var/lib/mysql//localhost.localdomain.pid
- ERROR! The server quit without updating PID file (/var/lib/mysql//localhost.localdomain.pid
- ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid)
- fedora20 Starting MySQL. ERROR! The server quit without updating PID file /var/lib/mysql/Master.Hado
- Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdom
- mysql启动报错:The server quit without updating PID file (/var/lib/mysql/
- Starting MySQL.The server quit without updating PID file (/var/lib/mysql/localhost.jeep.pid)
- macOS The server quit without updating PID file (/usr/local/var/mysql/XXX.local.pid)
- The server quit without updating PID file (/var/lib/mysql/localhost.pid)的解决办法
- The server quit without updating PID file (/var/lib/mysql/localhost.pid)
- Centos6 下 Mysql启动提示 Starting MySQL. ERROR! The server quit without updating PID file
- ERROR! The server quit without updating PID file (/usr/local/var/mysql/andy.local.pid)
- ERROR! The server quit without updating PID file (/usr/local/var/mysql/ericliu.pid).
- MySQL提示:The server quit without updating PID file
- MySQL提示:The server quit without updating PID file
- 2017瀚纳仕亚洲薪酬指南
- Java对象内存结构
- 路由器基础知识详解
- PHP-简单数据库和购物车类
- Java的Sizeof实现
- Centos7启动mysql5.6 提示ERROR! The server quit without updating PID file (/var/lib/mysql/XXX.pid).
- 整数划分类问题求递推式
- ※JVM内存模型※
- alpha策略量化投资的实证研究(二)
- Java 处理 XML 的三种主流技术及介绍
- HttpClient多线程并发问题
- opencv 一些函数的耗时计算
- spring如何读取properties文件
- 透明网桥