mysql-8.0.11 mysqld --initialize-insecure --user=mysql

2021/9/8 19:06:29

本文主要是介绍mysql-8.0.11 mysqld --initialize-insecure --user=mysql,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

D:\Eric\test\mysql-8.0.11-winx64\bin>mysqld --initialize-insecure --user=mysql
mysqld: Can't create/write to file 'D:\Eric  est\mysql-8.0.11-winx64\data\is_writable' (OS errno 2 - No such file or directory)
2021-09-08T08:45:15.620662Z 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.
2021-09-08T08:45:15.620734Z 0 [System] [MY-013169] [Server] D:\Eric\test\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 339828
2021-09-08T08:45:15.620847Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'D:\Eric    est\mysql-8.0.11-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2021-09-08T08:45:15.622772Z 0 [ERROR] [MY-010460] [Server] --initialize specified but the data directory exists and is not writable. Aborting.
2021-09-08T08:45:15.623595Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-09-08T08:45:15.624366Z 0 [System] [MY-010910] [Server] D:\Eric\test\mysql-8.0.11-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.

初始化报错

 

修改 my.ini

basedir =D:\\Eric\\test\\mysql-8.0.11-winx64
datadir =D:\\Eric\\test\\mysql-8.0.11-winx64\\data

Server =D:\\Eric\\test\\mysql-8.0.11-winx64\\bin\\mysqld.exe



这篇关于mysql-8.0.11 mysqld --initialize-insecure --user=mysql的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!


扫一扫关注最新编程教程