关于mysql安装过程中命令mysqld --initialize --console出错的解答
在进行mysql数据库安装时遇到以下问题,在网上找了一圈高赞帖子,但是都没有解决。
F:\study\mysql\mysql-8.0.25-winx64\bin>mysqld --initialize --console 2021-07-11T14:28:40.798214Z 0 [System] [MY-013169] [Server] F:\study\mysql\mysql-8.0.25-winx64\bin\mysqld.exe (mysqld 8.0.25) initializing of server in progress as process 5896 2021-07-11T14:28:40.815000Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2021-07-11T14:28:40.815015Z 0 [ERROR] [MY-013236] [Server] The designated data directory F:\study\mysql\mysql-8.0.25-winx64\ is unusable. You can remove all files that the server added to it. 2021-07-11T14:28:40.821104Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-07-11T14:28:40.822328Z 0 [System] [MY-010910] [Server] F:\study\mysql\mysql-8.0.25-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.25) MySQL Community Server - GPL.
最后的解决的措施有2步:
1、设置my.ini文件(如下)
2、设置数据库的数据存放目录:datadir=F:/study/mysql/mysql-8.0.25-winx64/data,同时确保data目录下没有文件,为空
3、将mysql安装地址配置到系统环境变量
[mysqld] # 设置3306端口 port=3306 # 设置mysql的安装目录 basedir=F:/study/mysql/mysql-8.0.25-winx64 # 设置mysql数据库的数据的存放目录 datadir=F:/study/mysql/mysql-8.0.25-winx64/data # 允许最大连接数 max_connections=200 # 允许连接失败的次数。 max_connect_errors=10 # 服务端使用的字符集默认为utf8mb4 character-set-server=utf8mb4 # 创建新表时将使用的默认存储引擎 default-storage-engine=INNODB # 默认使用“mysql_native_password”插件认证 #mysql_native_password default_authentication_plugin=mysql_native_password [mysql] # 设置mysql客户端默认字符集 default-character-set=utf8mb4 [client] # 设置mysql客户端连接服务端时默认使用的端口 port=3306 default-character-set=utf8mb4
再次执行就ok了.
F:\study\mysql\mysql-8.0.25-winx64\bin>mysqld --initialize --console 2021-07-11T14:55:39.337661Z 0 [System] [MY-013169] [Server] F:\study\mysql\mysql-8.0.25-winx64\bin\mysqld.exe (mysqld 8.0.25) initializing of server in progress as process 17800 2021-07-11T14:55:39.446137Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-07-11T14:55:43.233879Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2021-07-11T14:55:49.341436Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: XXXXXX