mysql8.0.15安装后,启动时服务一直是activating (start)

发布于 2022-09-11 18:51:37 字数 3460 浏览 42 评论 0

  1. 安装环境
    aliyun centos7
  2. 安装

            rpm -ivh mysql-community-libs-compat-8.0.13-1.el7.x86_64.rpm
            rpm -ivh mysql-community-embedded-compat-8.0.13-1.el7.x86_64.rpm
            rpm -ivh mysql-community-devel-8.0.13-1.el7.x86_64.rpm
            rpm -ivh mysql-community-test-8.0.13-1.el7.x86_64.rpm
  3. 启动mysql
    systemctl start mysqld
    然后就卡住了

    在另一个端口登录查看服务状态,一直是activating (start),求教各位这是什么原因?

     systemctl status mysqld
    mysqld.service - MySQL Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
       Active: activating (start) since Mon 2019-04-01 18:10:14 CST; 27s ago
         Docs: man:mysqld(8)
               http://dev.mysql.com/doc/refman/en/using-systemd.html
     Main PID: 1846 (mysqld)
       CGroup: /system.slice/mysqld.service
               └─1846 /usr/sbin/mysqld

    我另一个服务器是正常的

    systemctl status mysqld
    mysqld.service - MySQL Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
       Active: active (running) since Sun 2019-03-31 11:14:20 CST; 1 day 6h ago
         Docs: man:mysqld(8)
               http://dev.mysql.com/doc/refman/en/using-systemd.html
      Process: 2836 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
     Main PID: 3850 (mysqld)
       Status: "SERVER_OPERATING"
        Tasks: 38
       Memory: 117.5M
       CGroup: /system.slice/mysqld.service
               └─3850 /usr/sbin/mysqld
    
    Mar 31 11:13:53 VM_0_14_centos systemd[1]: Starting MySQL Server...
    Mar 31 11:14:20 VM_0_14_centos systemd[1]: Started MySQL Server.

    查看错误日志,没看到错误
    vi /var/log/mysqld.log

    2019-04-01T17:39:48.568242+08:00 0 [Warning] [MY-011807] [Server] Failed to connect to systemd notification socket named @/org/freedesktop/systemd1/notify. Error: 'No such file or directory'
    2019-04-01T17:39:48.895927+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 2784
    2019-04-01T17:39:49.702902+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
    2019-04-01T17:39:49.736468+08:00 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
    2019-04-01T17:39:49.898543+08:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
    2019-04-01T18:04:53.577979+08:00 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15)  MySQL Community Server - GPL.
    2019-04-01T18:10:17.004299+08:00 0 [Warning] [MY-011807] [Server] Failed to connect to systemd notification socket named @/org/freedesktop/systemd1/notify. Error: 'No such file or directory'
    2019-04-01T18:10:17.363327+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 1846
    2019-04-01T18:10:18.538619+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
    2019-04-01T18:10:18.607642+08:00 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
    2019-04-01T18:10:18.722219+08:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060

    请各位大神赐教!!!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

半窗疏影 2022-09-18 18:51:37

您好,我也遇到相同的问题,无法解决;请问您解决此问题了吗

黑色毁心梦 2022-09-18 18:51:37

楼主应该解决了吗?
我也出现了你后面报错的问题.
2019-04-01T17:39:48.895927+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 2784
2019-04-01T17:39:49.702902+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-04-01T17:39:49.736468+08:00 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2019-04-01T17:39:49.898543+08:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060

后面我解决了,删除了/var/run/mysqld/下的文件,然后重新启动mysql就可以了。

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文