宝塔用户_inkvmy 发表于 2024-3-14 11:36:03

【已完成】阿里云的服务器重启之后,宝塔安装的mysql无法...

为了能快速了解并处理您的问题,请提供以下基础信息:面板、插件版本:宝塔版本8.0.5,mysql版本8.0.36
系统版本:CentOS Stream 9 64位 4核16g
问题描述:在阿里云控制台重启服务器之后,宝塔面板重启之后mysql不会自动重启
相关截图(日志、错误):



宝塔用户_inkvmy 发表于 2024-3-14 11:37:07

自检了一下没有问题

宝塔用户_inkvmy 发表于 2024-3-14 11:37:39

重启之后查看错误日志
2024-03-14T02:15:43.825182Z 8 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:15:43.832955Z 9 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:15:51.068528Z 10 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:16:14.642404Z 11 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:16:16.915376Z 12 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:16:16.921462Z 13 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:16:17.530089Z 14 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:16:20.441761Z 15 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:16:20.447588Z 16 Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-03-14T02:21:25.172527Z 0 Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
2024-03-14T02:21:26.390044Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36)Source distribution.

阿珂 发表于 2024-3-14 14:25:47

目前所知CentOS Stream 9启动管理方式不一样,是有可能导致部分服务没有办法自启动
可以自行尝试加入systemd管理器管理自启动
然后提供的日志,只是一个警告,不算错误信息,如果手动启动成功可以忽略

宝塔用户_inkvmy 发表于 2024-3-14 15:03:36

阿珂 发表于 2024-3-14 14:25
目前所知CentOS Stream 9启动管理方式不一样,是有可能导致部分服务没有办法自启动
可以自行尝试加入system ...

手动可以启动成功,就是每次重启服务器之后mysql不能自动重启

阿珂 发表于 2024-3-14 15:18:33

你可以自己写给脚本,然后通过systemd管理自启动

宝塔用户_inkvmy 发表于 2024-3-14 15:27:05

阿珂 发表于 2024-3-14 15:18
你可以自己写给脚本,然后通过systemd管理自启动
利用宝塔里的定时任务,新建一个shell脚本,每分钟检测执行一次是不是也可以?
页: [1]
查看完整版本: 【已完成】阿里云的服务器重启之后,宝塔安装的mysql无法...