将下载好的安装包 mysql-5.7.33-winx64.zip
,解压到D盘下,并重命名为 mysql-5.7.33
,如图所示:
本次安装,将MySQL的数据文件夹创建在MySQL软件包下,目录为:D:\mysql-5.7.33\data
在mysql的根目录下,新建配置文件my.ini
,并添加如下配置:
[client]
port=3306
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
port = 3306
basedir = D:/mysql-5.7.33
datadir = D:/mysql-5.7.33/data
max_connections=200
character-set-server=utf8
default-storage-engine=innodb
mysqld --initialize
mysqld --install
net start mysql
D:/mysql-5.7.33/data
,会生成一个主机名.err
的文件,用编辑器打开:(J%w5Mc;h:uU
2021-04-22T15:37:23.629939Z 1 [Note] A temporary password is generated for root@localhost: (J%w5Mc;h:uU
使用上面的root用户初始化密码,在命令行客户端中登陆:
D:\mysql-5.7.33>mysql -u root -p
Enter password: ************ 此处为上一步中的初始化密码(J%w5Mc;h:uU
执行修改密码脚本,并且只允许本机使用root用户登陆
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘123456‘;
至此,MySQL数据库已经成功安装。
D:\mysql-5.7.33>mysqld --initialize
2021-04-22T15:36:48.568164Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-04-22T15:36:48.752785Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2021-04-22T15:36:48.753490Z 0 [ERROR] Aborting
解决方法:清空数据文件夹D:/mysql-5.7.33/data
下的所以文件
原文:https://www.cnblogs.com/neilweixing/p/14692070.html