MySQL无法启动服务,查找错误内容如下,但不知如何解决,求指教!!
D:\Download\mysql-8.0.23-winx64\bin>mysqld --console
2022-12-13T07:29:59.945679Z 0 [Warning] [MY-000081] [Server] option 'wait_timeout': unsigned value 31536000 adjusted to 2147483.
2022-12-13T07:29:59.945701Z 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-12-13T07:29:59.946031Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2022-12-13T07:29:59.946088Z 0 [System] [MY-010116] [Server] D:\Download\mysql-8.0.23-winx64\bin\mysqld.exe (mysqld 8.0.23) starting as process 11148
2022-12-13T07:29:59.947866Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2022-12-13T07:29:59.964497Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-12-13T07:30:00.464990Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2022-12-13T07:30:00.621471Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2022-12-13T07:30:00.621948Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.622333Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.622710Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.623099Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.623544Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.623996Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.624459Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.628191Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2022-12-13T07:30:00.671623Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-12-13T07:30:00.778334Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-12-13T07:30:00.783930Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-12-13T07:30:00.784431Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-12-13T07:30:00.788341Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2022-12-13T07:30:00.788988Z 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
2022-12-13T07:30:00.789412Z 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.
2022-12-13T07:30:00.792534Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=256M'.
2022-12-13T07:30:00.793973Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-12-13T07:30:01.865708Z 0 [System] [MY-010910] [Server] D:\Download\mysql-8.0.23-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.
my.ini配置文件
[mysql]
default-character-set=utf8
[mysqld]
port = 3306
basedir= D:\\Download\\mysql-8.0.23-winx64
datadir= D:\\Download\mysql-8.0.23-winx64\\data
max_connections=20
character-set-server=utf8
default-storage-engine=INNODB
secure_file_priv =
你贴的配置文件中 并没有报错中提示的“'query_cache_size=256M'” ,你可以确认下 mysql 的配置文件是否是用的你贴的这个