Open FanKang2021 opened 1 week ago
My version is 8.0.36.
2024-11-14T03:06:36.542402Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_auth_socket=FORCE_PLUS_PERMANENT'. 2024-11-14T03:06:36.542476Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_group_replication_recovery_use_ssl=1'. 2024-11-14T03:06:36.568948Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server' 2024-11-14T03:06:36.569047Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5 2024-11-14T03:06:36.569694Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections' 2024-11-14T03:06:36.570158Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36' socket: '/var/run/mysqld/mysql.sock' port: 3306 MySQL Community Server - GPL. 2024-11-14T03:06:36.570238Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2024-11-14T03:06:36.581998Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-11-14T03:06:36.582283Z 8 [Note] [MY-010926] [Server] Access denied for user 'localroot'@'localhost' (using password: NO) 2024-11-14T03:06:40.633697Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-11-14T03:06:40.633888Z 9 [Note] [MY-010926] [Server] Access denied for user 'localroot'@'localhost' (using password: NO) 2024-11-14T03:06:40.979164Z 10 [Note] [MY-010926] [Server] Access denied for user 'mysqlhealthchecker'@'localhost' (using password: NO) 2024-11-14T03:06:45.968604Z 11 [Note] [MY-010926] [Server] Access denied for user 'mysqlhealthchecker'@'localhost' (using password: NO)
when i configuration my.cnf after,it's not work still: plugin-load=AUDIT=libaudit_plugin.so default_authentication_plugin=caching_sha2_password
I inserted the plugin into the mysql/community-server image, but it failed to initialize:
2024-11-11T06:45:56.168676Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2024-11-11T06:45:56.169035Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2024-11-11T06:45:56.169103Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2024-11-11T06:45:56.169288Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_auth_socket=FORCE_PLUS_PERMANENT'. 2024-11-11T06:45:56.169311Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_group_replication_recovery_use_ssl=1'. 2024-11-11T06:45:56.170112Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2024-11-11T06:45:56.170197Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual. 2024-11-11T06:45:56.170350Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-11-11T06:45:56.171610Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
My configuration is as follows: