本来正常运行的数据库,在用navicat创建用户的时候突然崩了,崩的原因应该和这个操作有关系
用docker ps ,看到mysql容器没有运行
然后用docker restart 命令重启
再用docker ps ,还是没有启动。用docker ps -a 看一下
一启动就退出了。然后用这个命令看看日志
日志内容如下:
Initializing database
2018-07-03T06:27:14.184425Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-07-03T06:27:14.184479Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-07-03T06:27:14.184569Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.11) initializing of server in progress as process 31
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-03T06:27:16.374165Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2018-07-03T06:27:17.886264Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.11) initializing of server has completed
Database initialized
MySQL init process in progress...
2018-07-03T06:27:19.568448Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-07-03T06:27:19.568540Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-07-03T06:27:19.568634Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 82
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-03T06:27:20.042603Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-07-03T06:27:20.044450Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2018-07-03T06:27:20.076034Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.11' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2018-07-03T06:27:24.635641Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
MySQL init process done. Ready for start up.
2018-07-03T06:27:25.056741Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-07-03T06:27:25.056815Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-07-03T06:27:25.056920Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 1
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-03T06:27:25.540218Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-07-03T06:27:25.541969Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2018-07-03T06:27:25.574858Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.11' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
2018-07-03T06:35:22.546753Z 10 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
mbind: Operation not permitted
2018-07-03T06:48:19.831355Z 12 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-03T09:33:23.403659Z 18 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-07-04T01:03:05.628558Z 20 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-07-06T01:08:08.938364Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
2018-07-06T03:24:34.804321Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-07-06T03:24:34.804390Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-07-06T03:24:34.804470Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 1
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-06T03:24:35.365549Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-07-06T03:24:35.367638Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2018-07-06T03:24:35.404792Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.11' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
2018-07-06T03:32:05.695513Z 8 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
mbind: Operation not permitted
2018-07-06T08:54:52.899257Z 10 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-07-13T01:48:42.772094Z 26 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-19T07:47:27.642163Z 53 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-07-19T23:10:02.044417Z 110 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-07-23T04:31:37.064574Z 119 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-07-25T06:17:39.409369Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
2018-07-25T06:18:34.244980Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-07-25T06:18:34.245059Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-07-25T06:18:34.245147Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 1
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-25T06:18:34.737603Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-07-25T06:18:34.739319Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2018-07-25T06:18:34.777733Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.11' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
2018-07-25T07:29:59.056547Z 8 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
mbind: Operation not permitted
2018-07-25T07:45:49.406662Z 14 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
mbind: Operation not permitted
2018-07-25T23:10:07.283228Z 117 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-07-26T02:47:55.158647Z 141 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
mbind: Operation not permitted
2018-08-07T03:03:27.049818Z 1412 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-08-08T23:10:02.555339Z 1539 [Warning] [MY-010056] [Server] Host name 'bogon' could not be resolved: Name or service not known
2018-08-09T02:28:04.117104Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 1560 user: 'nanrou'.
2018-08-09T02:28:04.117313Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 1330 user: 'nanrou'.
2018-08-09T02:28:04.117478Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 139 user: 'nanrou'.
2018-08-09T02:28:04.117628Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 1558 user: 'nanrou'.
2018-08-09T02:28:04.117756Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 1559 user: 'nanrou'.
2018-08-09T02:28:04.117855Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 135 user: 'nanrou'.
2018-08-09T02:28:05.711577Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
本人小白,请教一下各位这个要怎么解决!!!有偿!
应该和权限有关
可以改一下数据库的密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';