【待反馈】MySQL无法启动
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：v11.5.0系统版本：Ubuntu 22.04.5 LTS
问题描述：MySQL无法启动
相关截图（日志、错误）：# Time: 2026-01-09T02:00:19.550020Z# User@Host: aaaqqqwwcn @ localhost Id: 106608# Query_time: 15.000581 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106617# Query_time: 6.000574 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106618# Query_time: 15.000631 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106622# Query_time: 3.000671 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106629# Query_time: 6.000504 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106630# Query_time: 25.000640 Lock_time: 0.000029 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106759# Query_time: 15.000553 Lock_time: 0.000014 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106760# Query_time: 6.000561 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106761# Query_time: 3.000620 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106762# Query_time: 15.000628 Lock_time: 0.000017 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106765# Query_time: 6.000665 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106766# Query_time: 25.000639 Lock_time: 0.000017 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106798# Query_time: 15.000535 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106799# Query_time: 15.000560 Lock_time: 0.000014 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106804# Query_time: 6.000533 Lock_time: 0.000013 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106805# Query_time: 3.000554 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106821# Query_time: 6.000631 Lock_time: 0.000030 Rows_sent: 0 Rows_examined: 3SET 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 @ localhost Id: 106822# Query_time: 25.000684 Lock_time: 0.000042 Rows_sent: 0 Rows_examined: 3SET 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.sockTime Id Command Argument/www/server/mysql/bin/mysqld, Version: 5.7.43-log (Source distribution). started with:Tcp port: 3306 Unix socket: /tmp/mysql.sockTime 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.sockTime Id Command Argument
您好，默认的mysql错误日志在 /www/server/data/主机名.err
您可以执行下面命令获取mysql的错误日志截图提交上来即可
cat /www/server/data/*.err|grep -i -C 10 error 大炮运维V587 发表于 2026-2-6 17:25
您好，默认的mysql错误日志在 /www/server/data/主机名.err
您可以执行下面命令获取mysql的错误日志截图提 ...
大炮运维V587 发表于 2026-2-6 17:25
您好，默认的mysql错误日志在 /www/server/data/主机名.err
您可以执行下面命令获取mysql的错误日志截图提 ...
页:
[1]