windows10+mysql8.0.11zip安装

超、凢脫俗 2022-05-22 05:27 192阅读 0赞

# 准备： #

MySQL8.0 Windows zip包下载地址：[https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip][https_cdn.mysql.com_Downloads_MySQL-8.0_mysql-8.0.11-winx64.zip]

环境：Windows 10

一、安装

### 1. 解压zip包到安装目录 ###

我的安装目录是D:\\Program Files\\mysql-8.0.11-winx64

### 2.配置文件 ###

windows系统中配置文件默认是安装目录下的 **my.ini** 文件，部分配置需要在初始安装时配置，大部分也可以在安装完成后进行更改，不知道别人是什么情况，我的是该文件目录下不存在my.ini文件，所以我新建了该文件，如下

![1347866-20180501190454432-28323776.png][]

写入基本配置如下：

![复制代码][copycode.gif]

1 [mysqld]
     2 default_authentication_plugin=mysql_native_password
     3 # Remove leading # and set to the amount of RAM for the most important data
     4 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
     5 # innodb_buffer_pool_size = 128M
     6 
     7 # Remove leading # to turn on a very important data integrity option: logging
     8 # changes to the binary log between backups.
     9 # log_bin
    10 
    11 # These are commonly set, remove the # and set as required.

# (这两行是主要修改的内容，会自动生成data文件夹，其他直接粘贴即可）

12 basedir=D:\\Program Files\\mysql-8.0.11-winx64 13 datadir=D:\\Program Files\\mysql-8.0.11-winx64\\data 14 port = 3306 15 \# server\_id = ..... 16 17 18 \# Remove leading \# to set options mainly useful for reporting servers. 19 \# The server defaults are faster for transactions and fast SELECTs. 20 \# Adjust sizes as needed, experiment to find the optimal values. 21 \# join\_buffer\_size = 128M 22 \# sort\_buffer\_size = 2M 23 \# read\_rnd\_buffer\_size = 2M  24 25 sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES  26 27 character-set-server = utf8mb4 28 29 performance\_schema\_max\_table\_instances = 600 30 table\_definition\_cache = 400 31 table\_open\_cache = 256 32 33 \[mysql\] 34 default-character-set = utf8mb4 35 36 \[client\] 37 default-character-set = utf8mb4

![复制代码][copycode.gif]

注意，里面的 basedir 是我本地的安装目录，datadir 是我数据库数据文件要存放的位置，各项配置需要根据自己的环境进行配置。

## 怎样将Mysql注册到win服务里面去呢？ ##

1.进入MySQL的bin目录   
![这里写图片描述][SouthEast]   
2.在命令行窗口输入：mysqld –install，回车，提示：Service successfully installed，代表注册服务成功。   
![这里写图片描述][SouthEast 1]

### 3.初始化数据库 ###

在MySQL安装目录的 bin 目录下执行命令：

mysqld --initialize --console

执行完成后，会打印 root 用户的初始默认密码，比如：

2018-05-01T14:35:01.507037Z 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. 2018-05-01T14:35:01.507640Z 0 [System] [MY-013169] [Server] D:\Program\MySQL8\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 11064 2018-05-01T14:35:01.508173Z 0 [ERROR] [MY-010340] [Server] Error message file 'D:\Program Files\mysql-8.0.11-winx64\share\english\errmsg.sys' had only 1090 error messages, but it should contain at least 4512 error messages. Check that the above file is the right version for this program! 2018-05-01T14:35:05.464644Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: APWCY5ws&hjQ 2018-05-01T14:35:07.017280Z 0 [System] [MY-013170] [Server] D:\Program\MySQL8\bin\mysqld.exe (mysqld 8.0.11) initializing of server has completed

其中，第4行的“APWCY5ws&hjQ”就是初始密码，在没有更改密码前，需要记住这个密码，后续登录需要用到。

要是你手贱，关快了，或者没记住，那也没事，删掉初始化的 datadir 目录，再执行一遍初始化命令，又会重新生成的。当然，也可以使用安全工具，强制改密码，用什么方法，自己随意。

4.配置环境变量   
path 下配置 D:\\Program Files\\mysql-8.0.11-winx64\\bin

5.安装数据库服务：   
以管理员身份运行cmd, 执行如下命令：

# 服务名缺省值为 mysql 
    mysqld --install mysql

*  1
 *  2

若不是管理员身份运行cmd ,会有如下错误报出。。。

mysql Install/Remove of the Service Denied!

*  1

6.启动mysql数据库服务

net start mysql

*  1

7.修改初始化密码

# 登录
    mysql -uroot -p初始化密码
    # 修改密码
     alter user 'root'@'localhost' identified by 'xxxxx';

![70][]

[https_cdn.mysql.com_Downloads_MySQL-8.0_mysql-8.0.11-winx64.zip]: https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip
[1347866-20180501190454432-28323776.png]: /images/20220522/82c65b5dad964ac8b1965abc34c9d853.png
[copycode.gif]: /images/20220522/e846580be5dc489aa2e45af55b5e23c5.png
[SouthEast]: /images/20220522/ea86f49be6f240b0b18a69fb697a671a.png
[SouthEast 1]: /images/20220522/0b35e0651d4042c28c17bfc68f530a81.png
[70]: /images/20220522/d4b3ae4a8d50438c9b225c94fc2eb32a.png