当前位置:论坛首页 > Linux面板 > 求助

【待反馈】MySQL无法启动

发表在 Linux面板2026-2-6 16:50 [复制链接] 3 327

为了能快速了解并处理您的问题,请提供以下基础信息:
面板、插件版本:v11.5.0

系统版本:Ubuntu 22.04.5 LTS

问题描述:MySQL无法启动

相关截图(日志、错误):
# Time: 2026-01-09T02:00:19.550020Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106608
# Query_time: 15.000581 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924019;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:00:25.835549Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106617
# Query_time: 6.000574 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924025;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:00:41.122473Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106618
# Query_time: 15.000631 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924041;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:00:44.413622Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106622
# Query_time: 3.000671 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924044;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(3)))v)/*'+(select(0)from(select(sleep(3)))v)+'"+(select(0)from(select(sleep(3)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:00:51.278233Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106629
# Query_time: 6.000504 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924051;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:01:16.567540Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106630
# Query_time: 25.000640 Lock_time: 0.000029 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924076;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(25)))v)/*'+(select(0)from(select(sleep(25)))v)+'"+(select(0)from(select(sleep(25)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:02:30.474705Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106759
# Query_time: 15.000553 Lock_time: 0.000014 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924150;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:02:37.049919Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106760
# Query_time: 6.000561 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924157;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:02:40.875752Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106761
# Query_time: 3.000620 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924160;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(3)))v)/*'+(select(0)from(select(sleep(3)))v)+'"+(select(0)from(select(sleep(3)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:02:56.158219Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106762
# Query_time: 15.000628 Lock_time: 0.000017 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924176;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:03:02.992561Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106765
# Query_time: 6.000665 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924182;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:03:28.271899Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106766
# Query_time: 25.000639 Lock_time: 0.000017 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924208;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(25)))v)/*'+(select(0)from(select(sleep(25)))v)+'"+(select(0)from(select(sleep(25)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:03:53.188185Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106798
# Query_time: 15.000535 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924233;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:04:08.467297Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106799
# Query_time: 15.000560 Lock_time: 0.000014 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924248;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:04:14.745775Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106804
# Query_time: 6.000533 Lock_time: 0.000013 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924254;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:04:18.024373Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106805
# Query_time: 3.000554 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924258;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(3)))v)/*'+(select(0)from(select(sleep(3)))v)+'"+(select(0)from(select(sleep(3)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:04:24.867579Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106821
# Query_time: 6.000631 Lock_time: 0.000030 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924264;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
# Time: 2026-01-09T02:04:50.154723Z
# User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106822
# Query_time: 25.000684 Lock_time: 0.000042 Rows_sent: 0 Rows_examined: 3
SET timestamp=1767924290;
SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(25)))v)/*'+(select(0)from(select(sleep(25)))v)+'"+(select(0)from(select(sleep(25)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15;
/www/server/mysql/bin/mysqld, Version: 5.7.43-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.43-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/usr/sbin/mysqld, Version: 8.0.45-0ubuntu0.22.04.1 ((Ubuntu)). started with:
Tcp port: 0 Unix socket: /tmp/tmp.gKxjc7Ulzr/mysqld.sock
Time Id Command Argument

使用道具 举报 只看该作者 回复
发表于 2026-2-6 17:25:53 | 显示全部楼层
您好,默认的mysql错误日志在 /www/server/data/主机名.err
您可以执行下面命令获取mysql的错误日志截图提交上来即可
cat /www/server/data/*.err|grep -i -C 10 error
使用道具 举报 回复 支持 反对
发表于 2026-2-6 17:49:15 | 显示全部楼层
大炮运维V587 发表于 2026-2-6 17:25
您好,默认的mysql错误日志在 /www/server/data/主机名.err
您可以执行下面命令获取mysql的错误日志截图提 ...

4.png
使用道具 举报 回复 支持 反对
发表于 2026-2-6 17:49:56 | 显示全部楼层
大炮运维V587 发表于 2026-2-6 17:25
您好,默认的mysql错误日志在 /www/server/data/主机名.err
您可以执行下面命令获取mysql的错误日志截图提 ...

4.png
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术分析

工作时间:09:00至18:30

快速回复 返回顶部 返回列表