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

  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

    请各位大神赐教!!!

阅读 15.2k
2 个回答
新手上路,请多包涵

楼主应该解决了吗?
我也出现了你后面报错的问题.
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就可以了。

推荐问题