【已解答】mysql问题
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：系统版本：
问题描述：
mysql设置权限报错
相关截图（日志、错误）：option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2025-01-23T02:33:24.211419Z 0 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 169152025-01-23T02:33:24.234197Z 1 InnoDB initialization has started.2025-01-23T02:33:24.465505Z 1 InnoDB initialization has ended.2025-01-23T02:33:24.538898Z 0 X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock2025-01-23T02:33:24.657138Z 0 CA certificate ca.pem is self signed.2025-01-23T02:33:24.657304Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2025-01-23T02:33:24.674172Z 0 /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'socket: '/tmp/mysql.sock'port: 3306Source distribution.2025-01-23T02:33:24.916407Z 0 Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.24).2025-01-23T02:33:26.164371Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-01-23T02:33:27.373407Z 0 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2025-01-23T02:33:27.373484Z 0 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 176422025-01-23T02:33:27.396048Z 1 InnoDB initialization has started.2025-01-23T02:33:27.640177Z 1 InnoDB initialization has ended.2025-01-23T02:33:27.713173Z 0 X Plugin ready for connections. Socket: /tmp/mysqlx.sock2025-01-23T02:33:27.796819Z 0 CA certificate ca.pem is self signed.2025-01-23T02:33:27.796992Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2025-01-23T02:33:27.805748Z 0 /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'socket: '/tmp/mysql.sock'port: 0Source distribution.2025-01-23T02:33:35.443002Z 0 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2025-01-23T02:33:35.443074Z 0 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 183952025-01-23T02:33:35.485613Z 1 InnoDB initialization has started.2025-01-23T02:33:37.275203Z 1 InnoDB initialization has ended.2025-01-23T02:33:37.349736Z 0 X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock2025-01-23T02:33:37.362609Z 0 Starting XA crash recovery...2025-01-23T02:33:37.366919Z 0 XA crash recovery finished.2025-01-23T02:33:37.435736Z 0 CA certificate ca.pem is self signed.2025-01-23T02:33:37.435903Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2025-01-23T02:33:37.450929Z 0 /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'socket: '/tmp/mysql.sock'port: 3306Source distribution.2025-01-23T02:33:38.581700Z 8 IP address '101.200.78.39' could not be resolved: Name or service not known# timed out waiting for input: auto-logout
上面的信息中没有错误信息
并且都是2025年1月的
页:
[1]