1.解压mysqld到D:\javaSvr\mysql-8.4.2-winx64
2.在安装目录下创建my.ini
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[mysqld]
# 设置端口，不设置默认3306
port = 3306
# 允许最大连接数
max_connections=100
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
3.初始化mysql 记住密码
mysqld --initialize --console
2024-11-13T08:59:49.732893Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-11-13T08:59:49.745402Z 0 [System] [MY-013169] [Server] D:\javaSvr\mysql-8.4.2-winx64\bin\mysqld.exe (mysqld 8.4.2) initializing of server in progress as process 3432
2024-11-13T08:59:49.796949Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-13T08:59:53.929314Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-13T09:00:10.346984Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: EePPe+geD1&g
2024-11-13T09:00:24.646959Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
4.安装mysql
mysqld --install
5.启动mysql服务
net start mysql
6.登陆mysql 遇到密码含特殊字符时，密码单独输入
mysql -uroot -pEePPe+geD1&g
7.修改mysql密码
alter user 'root'@'localhost' identified by '111111';
未经允许不得转载：
红吉他 »
MySQL »
windows安装使用mysql8.4.2