百死不灭 2022-03-11 18:26 采纳率: 0%
浏览 22

mysql启动不了 Starting MySQL .. * Manager of pid-file quit without updating file,如何解决?

mysql启动不了
Starting MySQL
.. * Manager of pid-file quit without updating file.

问题日志


**220311 18:23:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
220311 18:23:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
220311 18:23:48 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0ubuntu0.12.04.2) starting as process 25799 ...
220311 18:23:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
220311 18:23:48 [Note] Plugin 'FEDERATED' is disabled.
220311 18:23:48 InnoDB: The InnoDB memory heap is disabled
220311 18:23:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
220311 18:23:48 InnoDB: Compressed tables use zlib 1.2.3.4
220311 18:23:48 InnoDB: Initializing buffer pool, size = 128.0M
220311 18:23:48 InnoDB: Completed initialization of buffer pool
220311 18:23:48 InnoDB: highest supported file format is Barracuda.
220311 18:23:48  InnoDB: Waiting for the background threads to start
220311 18:23:49 InnoDB: 5.5.46 started; log sequence number 368968204
220311 18:23:49 [Note] Server hostname (bind-address): '121.42.224.36'; port: 3306
220311 18:23:49 [Note]   - '121.42.224.36' resolves to '121.42.224.36';
220311 18:23:49 [Note] Server socket created on IP: '121.42.224.36'.
220311 18:23:49 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
220311 18:23:49 [ERROR] Do you already have another mysqld server running on port: 3306 ?
220311 18:23:49 [ERROR] Aborting

220311 18:23:49  InnoDB: Starting shutdown...
220311 18:23:50  InnoDB: Shutdown completed; log sequence number 368968204
220311 18:23:50 [Note] /usr/sbin/mysqld: Shutdown complete

220311 18:23:50 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended**

  • 写回答

1条回答 默认 最新

  • 丨封尘绝念斩丨 2022-03-11 22:11
    关注

    cat /data/mysql/Host\ A.err
    查看一下错误日志,你就找到原因了

    评论

报告相同问题?

问题事件

  • 创建了问题 3月11日

悬赏问题

  • ¥15 有没有可以帮我搞一个微信建群链接,包括群名称和群资料群头像那种,不会让你白忙
  • ¥15 stm32开发clion时遇到的编译问题
  • ¥15 lna设计 源简并电感型共源放大器
  • ¥15 如何用Labview在myRIO上做LCD显示?(语言-开发语言)
  • ¥15 Vue3地图和异步函数使用
  • ¥15 C++ yoloV5改写遇到的问题
  • ¥20 win11修改中文用户名路径
  • ¥15 win2012磁盘空间不足,c盘正常,d盘无法写入
  • ¥15 用土力学知识进行土坡稳定性分析与挡土墙设计
  • ¥70 PlayWright在Java上连接CDP关联本地Chrome启动失败,貌似是Windows端口转发问题