【已解答】mysql无法启动

2022-08-26T18:59:39.186711Z 709604 [Warning] [MY-010058] [Server] Hostname 'zg-0728e-181.stretchoid.com' does not resolve to '192.241.220.232'.
2022-08-26T23:54:07.057103Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2022-08-26T23:54:07.057174Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-08-26T23:54:07.057271Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 7856
2022-08-26T23:54:07.123325Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-08-26T23:54:08.560383Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-08-26T23:54:08.920394Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2022-08-26T23:54:08.995739Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2022-08-26T23:54:09.001955Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2022-08-26T23:54:09.163079Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-08-26T23:54:09.163253Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-08-26T23:54:09.233201Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution.
2022-08-27T00:28:31.087220Z 969 [Warning] [MY-010058] [Server] Hostname 'zg-0728d-47.stretchoid.com' does not resolve to '192.241.214.193'.

您好，这边并未发现具体错误信息，执行以下命令查看错误日志

1. cat /www/server/data/*.err|grep -i -C 10 error

复制代码