mysql8.0.15安装后,启动时服务一直是activating (start)
- 安装环境
aliyun centos7 安装
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
启动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.log2019-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 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(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就可以了。