【已解答】mysql问题

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：

系统版本：

问题描述：

mysql设置权限报错
  

相关截图（日志、错误）：

option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.

2025-01-23T02:33:24.211419Z 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.

2025-01-23T02:33:24.211510Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 16915

2025-01-23T02:33:24.234197Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2025-01-23T02:33:24.465505Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2025-01-23T02:33:24.538898Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock

2025-01-23T02:33:24.657138Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2025-01-23T02:33:24.657304Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2025-01-23T02:33:24.674172Z 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.

2025-01-23T02:33:24.916407Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.24).

2025-01-23T02:33:26.164371Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.

2025-01-23T02:33:27.373407Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.

2025-01-23T02:33:27.373484Z 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.

2025-01-23T02:33:27.373571Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 17642

2025-01-23T02:33:27.396048Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2025-01-23T02:33:27.640177Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2025-01-23T02:33:27.713173Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /tmp/mysqlx.sock

2025-01-23T02:33:27.796819Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2025-01-23T02:33:27.796992Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2025-01-23T02:33:27.805748Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'  socket: '/tmp/mysql.sock'  port: 0  Source distribution.

2025-01-23T02:33:35.443002Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.

2025-01-23T02:33:35.443074Z 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.

2025-01-23T02:33:35.443159Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 18395

2025-01-23T02:33:35.485613Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2025-01-23T02:33:37.275203Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2025-01-23T02:33:37.349736Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock

2025-01-23T02:33:37.362609Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...

2025-01-23T02:33:37.366919Z 0 [System] [MY-010232] [Server] XA crash recovery finished.

2025-01-23T02:33:37.435736Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2025-01-23T02:33:37.435903Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2025-01-23T02:33:37.450929Z 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.

2025-01-23T02:33:38.581700Z 8 [Warning] [MY-010055] [Server] IP address '101.200.78.39' could not be resolved: Name or service not known

[root@iZ2zecsh2xkuwc4r5mmfxeZ ~]# timed out waiting for input: auto-logout

上面的信息中没有错误信息
并且都是2025年1月的