shutting down mysql_linux系统mysql无法启动请求解决方案

最新推荐文章于 2022-09-15 15:54:37 发布
最新推荐文章于 2022-09-15 15:54:37 发布
阅读量772 收藏
点赞数
文章标签： shutting down mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35721505/article/details/114469730
版权

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

错误提示：Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/109.thxxg.pid).

错误日志：

170911 09:24:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

2017-09-11 09:24:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-09-11 09:24:33 31197 [Warning] ignore-builtin-innodb is ignored and will be removed in future releases.

2017-09-11 09:24:33 31197 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release

2017-09-11 09:24:33 31197 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release

2017-09-11 09:24:33 31197 [Warning] Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.

2017-09-11 09:24:33 31197 [Warning] Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.

2017-09-11 09:24:33 31197 [Warning] Using unique option prefix innodb-cmp-per-index instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.

2017-09-11 09:24:33 31197 [Note] Plugin 'InnoDB' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_TRX' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_CMPMEM' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_METRICS' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.

2017-09-11 09:24:33 31197 [Note] Plugin 'FEDERATED' is disabled.

2017-09-11 09:24:33 31197 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose-innodb-ft-inserted=0'

/usr/local/mysql/bin/mysqld: File './mysql-bin.000014' not found (Errcode: 2 - No such file or directory)

2017-09-11 09:24:33 31197 [ERROR] Failed to open log (file './mysql-bin.000014', errno 2)

2017-09-11 09:24:33 31197 [ERROR] Could not open log file

2017-09-11 09:24:33 31197 [ERROR] Can't init tc log

2017-09-11 09:24:33 31197 [ERROR] Aborting

2017-09-11 09:24:33 31197 [Note] Binlog end

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'partition'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'ARCHIVE'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'BLACKHOLE'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'INNODB_CMP'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'INNODB_LOCKS'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'MEMORY'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'CSV'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'MRG_MYISAM'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'MyISAM'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'sha256_password'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'mysql_old_password'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'mysql_native_password'

2017-09-11 09:24:33 31197 [Note] Shutting down plugin 'binlog'

2017-09-11 09:24:33 31197 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170911 09:24:33 mysqld_safe mysqld from pid file /usr/local/mysql/var/109.thxxg.pid ended

不藏私面包匠人
关注
mysql服务启动却连接不上的解决方法
01-19
mysql服务启动，但是连接不上，如何解决？ 登陆报错： root@localhost:~# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql....
shutting down mysql_MYSQL启动后报错故障问题的解决办法
weixin_39717318的博客
01-19 3151
MYSQL启动后报错故障问题的解决办法centos系统有一次异常关机后启动mysql一直报错#/etc/init.d/mysqld startStarting MySQL.. ERROR! The server quit without updating PID file (/data/mysql/linux-01.pid).查看错误日志如下[root@linux-01 ~]# tail /dat...
mysql_5.7.25启用binlog后mysql无法启动
weixin_40908896的博客
05-28 2572
mysql> select version(); ±----------+ | version() | ±----------+ | 5.7.25 | ±----------+ 1 row in set (0.00 sec) mysql> show variables like’%log_bin%’; ±--------------------------------±-----...
MySQL报错：The server quit without updating PID file 我的解决思路和方法
m0_59308369的博客
09-15 3万+
Starting MySQL. ERROR! The server quit without updating PID file Can't connect to local MySQL server through socket '/tmp/mysql.sock'的解决方法和思路
解决Linux上Mysql服务器异常挂掉的一次经历
MrHuang
12-25 5677
2018-12-25 14:49:57 25873 [Note] Plugin ‘FEDERATED’ is disabled. 2018-12-25 14:49:57 25873 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-12-25 14:49:57 25873 [Note] InnoDB: The Inno...
MySQL使用过程中报错记录
mts8939的博客
10-04 429
MySQL启动过程中一系列问题及解决办法记录 很久没有使用MySQL了，突然需要用到它，但是却在启动MySQL服务时候遇到一堆的问题，在此一一记录下来，以便后效。以下记录顺序为操作及遇到问题的顺序 启动mysql 在CMD中cd 到MySQL安装文件bin目录下输入命令：mysql -u root -p 然后输入密码。在这里遇到了第一个错误。Access denied for user ‘ro...
mysql 1067 privilege_mysql服务无法启动1067错误，谁知道正确的解决方法？
weixin_29959121的博客
01-27 1084
必须手动删除上面三个文件后才能启动服务：2016-04-29T03:14:39.211523Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more ...
SUSE Linux下通过RPM方式卸载MySQL 5过程笔记
09-10
Shutting down MySQL... done ``` 4. 使用rpm命令卸载MySQL包 在确认服务已经停止后，我们可以使用rpm命令的-e选项来卸载MySQL。参数--nodeps的作用是忽略依赖，直接卸载包。示例如下： ``` SZDB:~# rpm -e --...
MySQL关闭过程详解和安全关闭MySQL的方法
12-15
本文分析了mysqld进程关闭的过程，以及如何安全、缓和地关闭MySQL实例，对这个过程不甚清楚... 当无法创建独立的关闭线程时(例如内存不足)，MySQL Server会发出类似下面的告警信息：  Error: Can’t create thread to
MySql5.6使用validate password 插件加强密码强度的安装及使用方法
01-21
mysql 5.6对密码的强度进行了加强，推出了 validate_password 插件...mysql>>INSTALL PLUGIN validate_password SONAME 'validate_password.so'; 即可。 当建立用户密码时，如果不符合预设的规则，那么就不会通过： m
MySQL错误ERROR 2002 (HY000): Can't connect to local MySQL server through socket
09-10
Shutting down MySQL. [OK] ``` 2. 修改***f配置文件： ```bash [root@SZDBmysqldata]# vi /etc/***f ``` 将socket行改为指向实际存在的MySQL socket文件路径，例如： ```ini socket=/data/mysqldata/mysql.sock ``...
linux下启动mysql一直报错,MYSQL启动后报错故障问题的解决办法
weixin_30451613的博客
05-02 1465
MYSQL启动后报错故障问题的解决办法centos系统有一次异常关机后启动mysql一直报错#/etc/init.d/mysqld startStarting MySQL.. ERROR! The server quit without updating PID file (/data/mysql/linux-01.pid).查看错误日志如下[root@linux-01 ~]# tail /dat...
mysql ssl 1067_mysql服务无法启动1067错误，谁知道正确的解决方法？
weixin_42173218的博客
01-19 2035
必须手动删除上面三个文件后才能启动服务：2016-04-29T03:14:39.211523Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more ...
mysql启动失败 7000_mysql 5.7.11 启动报错
weixin_39821604的博客
02-02 265
安装使用homebrew 安装mysql 输入命令 brew install mysql启动安装完毕后，使用mysql.server start 启动mysql出错结果终端报错 ERROR! The server quit without updating PID file检查配置 文件为/usr/local/Cellar/mysql/5.7.11/support_files/my-default...
mysql启动的报错
weixin_34268169的博客
01-20 157
由于项目需要不得不折腾mysql,redhat上安装了最新的mysql 5.6启动报错如下：[root@tserver mysql]# /etc/init.d/mysql startStarting MySQL.The server quit without updating PID file (/var/lib/mysql/tserver.pid).[FAILED]检查报错...
centos selinux mysql_请教：CentOS 下 Mysql 无法启动， selinux 为disabled
weixin_39777540的博客
02-06 125
错误信息为：[root@server1 ~]# cat /usr/local/mysql/var/server1.err160916 12:17:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var2016-09-16 12:17:12 0 [Warning] TIMESTAMP with im...
mysql5.6
可问春风的博客
12-08 800
2021-12-08 19:47:57 3748 [Note] Plugin 'FEDERATED' is disabled. 2021-12-08 19:47:57 3748 [Warning] option 'innodb-buffer-pool-size': signed value 50 adjusted to 5242880 2021-12-08 19:47:57 3748 [Note] InnoDB: Using atomics to ref count buffer pool pages 20
mysql5.7.11源码安装,编译后MySQL v5.7.11安装出错
weixin_29514913的博客
03-17 322
在从源代码编译安装后尝试启动mysql服务器时,我在MAC OS X 10.11中遇到以下错误.keyring_file不可读.我试图使用以下命令启动服务器../mysqld start在终端中生成以下错误.2016-03-24T18:43:50.591772Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Ple...
docker挂在本地盘mysql无法启动_docker禅道开源版不挂载镜像可以启动，挂载镜像后mysql无法启动...
weixin_39845220的博客
02-06 710
docker禅道启动镜像时，不挂载目录可以正常启动，docker run -d -p 8080:80 -p 3306:3306 -e USER="admin" -e PASSWD="123456" -e BIND_ADDRESS="false" --name zentao-server idoop/zentao:latest挂载目录后mysql无法正常启动docker run -d -p 8080...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值