mysqld: Table 'mysql.plugin' doesn't exist

Issue Description / 问题描述

Please provide a detailed description of the error or issue you encountered. / 请详细描述您遇到的错误或问题。
多台机器上都无法运行mysql容器

Steps to Reproduce / 复现步骤

Please provide the specific steps to reproduce the error. / 请提供复现错误的具体步骤。
docker compose up中mysql报错

Expected Behavior / 预期行为

Describe the behavior you expected to see. / 请描述您期望的正确行为。

Environment / 环境信息

• Operating System / 操作系统：
• windows 11
• Python Version / Python 版本：
• python 3.11.4
• Other Relevant Information / 其他相关信息：

Error Screenshots or Logs / 错误截图或日志

If possible, please provide relevant screenshots or logs of the error. / 如果可能，请提供相关的错误截图或日志文件。
WARN[0000] /mnt/c/Users/lazym/Documents/XAgent/docker-compose.yml: version is obsolete
[+] Running 5/0
✔ Container xagent-db-1 Running 0.0s
✔ Container xagent-ToolServerNode-1 Running 0.0s
✔ Container xagent-xagent-redis-1 Running 0.0s
✔ Container xagent-xagent-mysql-1 Created 0.0s
✔ Container xagent-ToolServerManager-1 Running 0.0s
Attaching to XAgent-Server, ToolServerManager-1, ToolServerNode-1, db-1, xagent-mysql-1, xagent-redis-1
xagent-mysql-1 | 2024-06-17 10:27:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
xagent-mysql-1 | 2024-06-17 10:27:18+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
xagent-mysql-1 | 2024-06-17 10:27:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
xagent-mysql-1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
xagent-mysql-1 | 2024-06-17T10:27:18.268927Z 0 [System] [MY-015015] [Server] MySQL Server - start.
xagent-mysql-1 | 2024-06-17T10:27:18.477987Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
xagent-mysql-1 | 2024-06-17T10:27:18.490356Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
xagent-mysql-1 | 2024-06-17T10:27:18.632379Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
xagent-mysql-1 | mysqld: Table 'mysql.plugin' doesn't exist
xagent-mysql-1 | 2024-06-17T10:27:18.752296Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
xagent-mysql-1 | 2024-06-17T10:27:18.752481Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.752620Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.752746Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.753033Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.753244Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.753434Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.753615Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.789072Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
xagent-mysql-1 | 2024-06-17T10:27:18.854373Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
xagent-mysql-1 | 2024-06-17T10:27:18.860935Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
xagent-mysql-1 | 2024-06-17T10:27:18.860997Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
xagent-mysql-1 | 2024-06-17T10:27:18.867165Z 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.
xagent-mysql-1 | 2024-06-17T10:27:18.867646Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-06-17T10:27:18.867978Z 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
xagent-mysql-1 | 2024-06-17T10:27:18.868029Z 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.
xagent-mysql-1 | 2024-06-17T10:27:18.868189Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=caching_sha2_password'.
xagent-mysql-1 | 2024-06-17T10:27:18.869086Z 0 [ERROR] [MY-010119] [Server] Aborting
xagent-mysql-1 | 2024-06-17T10:27:20.409581Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
xagent-mysql-1 | 2024-06-17T10:27:20.409664Z 0 [System] [MY-015016] [Server] MySQL Server - end.
xagent-mysql-1 exited with code 1
dependency failed to start: container xagent-xagent-mysql-1 exited (1)

Additional Notes / 其他备注

If you have any additional information or notes, please add them here. / 如果有其他补充信息，请在此处添加。
docker inspect mysql容器结果：
[
{
"Id": "aaebc513469e024d5528f39eebcb0a2c93957cbad838f67527da849948db3020",
"Created": "2024-06-17T10:07:13.598707334Z",
"Path": "docker-entrypoint.sh",
"Args": [
"--default-authentication-plugin=caching_sha2_password",
"--character-set-server=utf8mb4",
"--collation-server=utf8mb4_unicode_ci"
],
"State": {
"Status": "exited",
"Running": false,
"Paused": false,
"Restarting": false,
"OOMKilled": false,
"Dead": false,
"Pid": 0,
"ExitCode": 1,
"Error": "",
"StartedAt": "2024-06-17T10:23:16.608145093Z",
"FinishedAt": "2024-06-17T10:23:19.309384805Z",
"Health": {
"Status": "unhealthy",
"FailingStreak": 0,
"Log": []
}
},
"Image": "sha256:fcd86ff8ce8c2d30f02607e184cbfd73eb581e22a451e4a1847a102318bc2926",
"ResolvConfPath": "/var/lib/docker/containers/aaebc513469e024d5528f39eebcb0a2c93957cbad838f67527da849948db3020/resolv.conf",
"HostnamePath": "/var/lib/docker/containers/aaebc513469e024d5528f39eebcb0a2c93957cbad838f67527da849948db3020/hostname",
"HostsPath": "/var/lib/docker/containers/aaebc513469e024d5528f39eebcb0a2c93957cbad838f67527da849948db3020/hosts",
"LogPath": "/var/lib/docker/containers/aaebc513469e024d5528f39eebcb0a2c93957cbad838f67527da849948db3020/aaebc513469e024d5528f39eebcb0a2c93957cbad838f67527da849948db3020-json.log",
"Name": "/xagent-xagent-mysql-1",
"RestartCount": 0,
"Driver": "overlay2",
"Platform": "linux",
"MountLabel": "",
"ProcessLabel": "",
"AppArmorProfile": "",
"ExecIDs": null,
"HostConfig": {
"Binds": [
"/mnt/c/Users/lazym/Documents/XAgent/XAgentServer/database/sql:/docker-entrypoint-initdb.d:rw"
],
"ContainerIDFile": "",
"LogConfig": {
"Type": "json-file",
"Config": {}
},
"NetworkMode": "tool-server-network",
"PortBindings": {
"3308/tcp": [
{
"HostIp": "",
"HostPort": "3308"
}
]
},
"RestartPolicy": {
"Name": "no",
"MaximumRetryCount": 0
},
"AutoRemove": false,
"VolumeDriver": "",
"VolumesFrom": null,
"ConsoleSize": [
0,
0
],
"CapAdd": null,
"CapDrop": null,
"CgroupnsMode": "host",
"Dns": null,
"DnsOptions": null,
"DnsSearch": null,
"ExtraHosts": [],
"GroupAdd": null,
"IpcMode": "private",
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
"ReadonlyRootfs": false,
"SecurityOpt": null,
"UTSMode": "",
"UsernsMode": "",
"ShmSize": 67108864,
"Runtime": "runc",
"Isolation": "",
"CpuShares": 0,
"Memory": 0,
"NanoCpus": 0,
"CgroupParent": "",
"BlkioWeight": 0,
"BlkioWeightDevice": null,
"BlkioDeviceReadBps": null,
"BlkioDeviceWriteBps": null,
"BlkioDeviceReadIOps": null,
"BlkioDeviceWriteIOps": null,
"CpuPeriod": 0,
"CpuQuota": 0,
"CpuRealtimePeriod": 0,
"CpuRealtimeRuntime": 0,
"CpusetCpus": "",
"CpusetMems": "",
"Devices": null,
"DeviceCgroupRules": null,
"DeviceRequests": null,
"MemoryReservation": 0,
"MemorySwap": 0,
"MemorySwappiness": null,
"OomKillDisable": false,
"PidsLimit": null,
"Ulimits": null,
"CpuCount": 0,
"CpuPercent": 0,
"IOMaximumIOps": 0,
"IOMaximumBandwidth": 0,
"Mounts": [
{
"Type": "volume",
"Source": "2ae34be83a7c3a1a691a13cccf615f26588c9d918dce0da052b2e087b21f9599",
"Target": "/var/lib/mysql"
}
],
"MaskedPaths": [
"/proc/asound",
"/proc/acpi",
"/proc/kcore",
"/proc/keys",
"/proc/latency_stats",
"/proc/timer_list",
"/proc/timer_stats",
"/proc/sched_debug",
"/proc/scsi",
"/sys/firmware",
"/sys/devices/virtual/powercap"
],
"ReadonlyPaths": [
"/proc/bus",
"/proc/fs",
"/proc/irq",
"/proc/sys",
"/proc/sysrq-trigger"
]
},
"GraphDriver": {
"Data": {
"LowerDir": "/var/lib/docker/overlay2/c9e736cec389dc86e5eee8f5eed0b8d73d9d364a5cd9d226a244a3dc7b734e7f-init/diff:/var/lib/docker/overlay2/0ac3c8ef33042a4a6040de61f0cd9a6ea8c8425cba516f1e12e682dfb2880852/diff:/var/lib/docker/overlay2/350cb8ab642d463cb192b20b4f37ec4fe6d185761ac5d0778b0c42a7a83a8bb7/diff:/var/lib/docker/overlay2/7bad8870150db36f4bda9876aa8d0c5a62208b50d5a5a98962e223c65838600a/diff:/var/lib/docker/overlay2/b7a85a1fd298d7e57b9ebae0604cbdacf9e6e53af9063e0d45b9374ec1d9c9a8/diff:/var/lib/docker/overlay2/6bdf02ddee4808497fd253f827daa706e375a6dd3144599976bc0ff986adbfbd/diff:/var/lib/docker/overlay2/1e85aea3404d5dfd9531c01bcdd97a0aed5dc60a354c7b72d15db93d1a59538f/diff:/var/lib/docker/overlay2/763f83295cc9902a9347cae2bc7d5a5d20ee6d9a11854f4f2029cc5ad155b0f6/diff:/var/lib/docker/overlay2/bce095ac6354bc7eb287ddb86f12512f08a5a0b70664bb93d8f0d59cb16ec0f0/diff:/var/lib/docker/overlay2/2cf723f278afd29b64365f3759f7f5e1dc8d4b0103eefa0b4f300ecffed180c7/diff:/var/lib/docker/overlay2/fca8984ac6b59c7ce4c08df8bf41509017b8de499a90fbd0cac5704e446574da/diff",
"MergedDir": "/var/lib/docker/overlay2/c9e736cec389dc86e5eee8f5eed0b8d73d9d364a5cd9d226a244a3dc7b734e7f/merged",
"UpperDir": "/var/lib/docker/overlay2/c9e736cec389dc86e5eee8f5eed0b8d73d9d364a5cd9d226a244a3dc7b734e7f/diff",
"WorkDir": "/var/lib/docker/overlay2/c9e736cec389dc86e5eee8f5eed0b8d73d9d364a5cd9d226a244a3dc7b734e7f/work"
},
"Name": "overlay2"
},
"Mounts": [
{
"Type": "bind",
"Source": "/mnt/c/Users/lazym/Documents/XAgent/XAgentServer/database/sql",
"Destination": "/docker-entrypoint-initdb.d",
"Mode": "rw",
"RW": true,
"Propagation": "rprivate"
},
{
"Type": "volume",
"Name": "2ae34be83a7c3a1a691a13cccf615f26588c9d918dce0da052b2e087b21f9599",
"Source": "/var/lib/docker/volumes/2ae34be83a7c3a1a691a13cccf615f26588c9d918dce0da052b2e087b21f9599/_data",
"Destination": "/var/lib/mysql",
"Driver": "local",
"Mode": "z",
"RW": true,
"Propagation": ""
}
],
"Config": {
"Hostname": "aaebc513469e",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": true,
"AttachStderr": true,
"ExposedPorts": {
"3306/tcp": {},
"33060/tcp": {},
"3308/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"MYSQL_ROOT_PASSWORD=xagent",
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"GOSU_VERSION=1.17",
"MYSQL_MAJOR=8.4",
"MYSQL_VERSION=8.4.0-1.el9",
"MYSQL_SHELL_VERSION=8.4.0-1.el9"
],
"Cmd": [
"--default-authentication-plugin=caching_sha2_password",
"--character-set-server=utf8mb4",
"--collation-server=utf8mb4_unicode_ci"
],
"Healthcheck": {
"Test": [
"CMD-SHELL",
"mysql -h localhost -u root -pxagent -e 'SELECT 1'"
],
"Timeout": 20000000000,
"Retries": 20
},
"Image": "mysql",
"Volumes": {
"/var/lib/mysql": {}
},
"WorkingDir": "",
"Entrypoint": [
"docker-entrypoint.sh"
],
"OnBuild": null,
"Labels": {
"com.docker.compose.config-hash": "a0ca7ed4d5e5330b63587f1d95799cc1fdf27fb8006dc43818fead2afaa67f71",
"com.docker.compose.container-number": "1",
"com.docker.compose.depends_on": "",
"com.docker.compose.image": "sha256:fcd86ff8ce8c2d30f02607e184cbfd73eb581e22a451e4a1847a102318bc2926",
"com.docker.compose.oneoff": "False",
"com.docker.compose.project": "xagent",
"com.docker.compose.project.config_files": "/mnt/c/Users/lazym/Documents/XAgent/docker-compose.yml",
"com.docker.compose.project.working_dir": "/mnt/c/Users/lazym/Documents/XAgent",
"com.docker.compose.replace": "45a54fd70868919fd92cad8d16629c45f6d1ba8d93f5e4c22d1914e3172f197f",
"com.docker.compose.service": "xagent-mysql",
"com.docker.compose.version": "2.27.0",
"desktop.docker.io/wsl-distro": "Ubuntu"
}
},
"NetworkSettings": {
"Bridge": "",
"SandboxID": "b00dae9f1f8688c9c05a0bde302845137856e5568a05093388d9c6c439c574ed",
"SandboxKey": "/var/run/docker/netns/b00dae9f1f86",
"Ports": {},
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"SecondaryIPAddresses": null,
"SecondaryIPv6Addresses": null,
"EndpointID": "",
"Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"IPAddress": "",
"IPPrefixLen": 0,
"IPv6Gateway": "",
"MacAddress": "",
"Networks": {
"tool-server-network": {
"IPAMConfig": null,
"Links": null,
"Aliases": [
"xagent-xagent-mysql-1",
"xagent-mysql"
],
"MacAddress": "",
"NetworkID": "36ac17273f37f765de57433784034245504661e62374080fc05fa1085ed0fafc",
"EndpointID": "",
"Gateway": "",
"IPAddress": "",
"IPPrefixLen": 0,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"DriverOpts": null,
"DNSNames": [
"xagent-xagent-mysql-1",
"xagent-mysql",
"aaebc513469e"
]
}
}
}
}
]

Start with docker-compose.yml and the mounted XAgentServer/database/sql directory, then reproduce the failure with docker compose up and review the MySQL 8.4 startup logs. Check how the MySQL data volume and initialization files are configured. Done means the MySQL container stays running and dependent services start without the missing-table or unknown-variable errors.