【待反馈】ip换了，然后mysql数据库就启动不了了
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：8.2.0系统版本：CentOS CentOS 7.6 64位
问题描述：ip换了，然后mysql数据库就启动不了了
相关截图（日志、错误）：
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=0
max_threads=500
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 206582 Kbytes of memory
Hope that＇s ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x40000
/www/server/mysql/bin/mysqld(my_print_stacktrace+0x2c)
/www/server/mysql/bin/mysqld(handle_fatal_signal+0x357)
/lib64/libpthread.so.0(+0xf630)
/lib64/libc.so.6(gsignal+0x37)
/lib64/libc.so.6(abort+0x148)
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld
/www/server/mysql/bin/mysqld(_Z24plugin_foreach_with_maskP3THDPFcS0_P13st_plugin_intPvEijS3_+0x23f)
/www/server/mysql/bin/mysqld(_Z10ha_recoverP7st_hash+0xcc)
/www/server/mysql/bin/mysqld(_ZN13MYSQL_BIN_LOG7recoverEP11st_io_cacheP28Format_description_log_eventPy+0x151)
/www/server/mysql/bin/mysqld(_ZN13MYSQL_BIN_LOG11open_binlogEPKc+0x7c7)
/www/server/mysql/bin/mysqld(_Z11mysqld_mainiPPc+0xc11)
/lib64/libc.so.6(__libc_start_main+0xf5)
/www/server/mysql/bin/mysqld
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash. 您好，您说ip换了是指什么意思呢，是服务器IP吗，还是您网站呢，数据库启动不了提示什么呢 服务器ip更换了，我想发日志但是提示我内容不合适 运维技术阿闯 发表于 2024-6-4 09:44
您好，您说ip换了是指什么意思呢，是服务器IP吗，还是您网站呢，数据库启动不了提示什么呢 ...
服务器ip更换了，我想发日志但是提示我内容不合适 宝塔用户_tyhjtv 发表于 2024-6-4 11:01
服务器ip更换了，我想发日志但是提示我内容不合适
您说的换ip是否有数据迁移呢。将启动不起来的图片发一下，
在您ssh终端执行/etc/init.d/mysql start
的截图也发一下 运维技术阿闯 发表于 2024-6-4 11:52
您说的换ip是否有数据迁移呢。将启动不起来的图片发一下，
在您ssh终端执行/etc/init.d/mysql start
的截 ...
不是数据迁移，就是单纯的服务器的ip换了，https://pan.baidu.com/s/1G1ejVYZtjaEWhSe92g2K3g?pwd=1rua 宝塔用户_tyhjtv 发表于 2024-6-4 12:29
不是数据迁移，就是单纯的服务器的ip换了，
https://pan.baidu.com/s/1G1ejVYZtjaEWhSe92g2K3g?pwd=1rua 运维技术阿闯 发表于 2024-6-4 11:52
您说的换ip是否有数据迁移呢。将启动不起来的图片发一下，
在您ssh终端执行/etc/init.d/mysql start
的截 ...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
这是执行完 宝塔用户_tyhjtv 发表于 2024-6-4 12:30
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
这 ...
您好，请参考一下解决方法
https://www.bt.cn/bbs/forum.php?mod=viewthread&tid=39414&extra=page%3D2%26filter%3Dtypeid%26typeid%3D10 运维技术阿闯 发表于 2024-6-4 15:29
您好，请参考一下解决方法
https://www.bt.cn/bbs/forum.php?mod=viewthread&tid=39414&extra=page%3D2%2 ...
现在报了这个Starting MySQL.. ERROR! The server quit without updating PID file (/www/server/data/lvbvGu1013686.pid).
但是我执行 chown -R mysql.mysql data在实行启动还是不可呐 宝塔用户_tyhjtv 发表于 2024-6-4 16:01
现在报了这个Starting MySQL.. ERROR! The server quit without updating PID file (/www/server/data/lv ...
您好，您在您ssh终端执行以下命令，将截图发来
cat /www/server/data/*.err|grep -i -C 10 error 运维技术阿闯 发表于 2024-6-4 16:09
您好，您在您ssh终端执行以下命令，将截图发来
https://bj.bcebos.com/v1/zq-presigned/45644e7a0e8c5df35a765c537bb821f4.png?authorization=bce-auth-v1%2F4215dd0350224a5caf8501eb90746b19%2F2024-06-04T08%3A57%3A40Z%2F300%2F%2Fb57f62b2c7eb76e92e0b671a83ddde0e265507610fcb1aa90f718286cb60e68f 宝塔用户_tyhjtv 发表于 2024-6-4 16:57
现在是这样 宝塔用户_tyhjtv 发表于 2024-6-4 16:58
现在是这样
您好，看不了您的图片，您需要点击高级模式，点击图片，通过上传的方式
页:
[1]
2