初始化mysql的数据库失败怎么办_初始化mysql的数据库失败怎么办

初始化mysql数据库失败的解决办法：首先找到并打开my.ini文件；然后注释掉my.ini文件中的datadir；最后根据提示把UTF8换成UTF8MB4即可。

数据库初始化时命令行出现的报错如下：C:\mysql-8.0.17-winx64\bin>mysqld --initialize --console

2019-08-24T13:33:22.622321Z 0 [System] [MY-013169] [Server] C:\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server in progress as process 8404

2019-08-24T13:33:22.624188Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.

2019-08-24T13:33:22.625619Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.

2019-08-24T13:33:22.625635Z 0 [ERROR] [MY-013236] [Server] The designated data directory C:\mysql-8.0.17-winx64\data\ is unusable. You can remove all files that the server added to it.

2019-08-24T13:33:22.643590Z 0 [ERROR