win10下mysql8.0.16免安装版配置

- 日理万妓 2021-12-19 14:49 275阅读 0赞

**背景：为了使用高版本的mysql，而又不删除原来低版本的mysql**

### 一、下载免安装版mysql ###

**下载地址：[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]**

**[https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.16-winx64.zip][https_cdn.mysql.com_Downloads_MySQL-8.0_mysql-8.0.16-winx64.zip]**

![2019063016295537.png][]

### 二、指定安装目录 ###

**解压文件到指定目录(此处为E:\\，安装目录为E:\\mysql-8.0.16-winx64)**

![20190630161438280.png][]

### **三、创建文件** ###

**1. 在mysql安装目录下（E:\\mysql-8.0.16-winx64）新建my.ini文件**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70][]

[mysql]
    # 设置mysql客户端默认字符集
    default-character-set=utf8mb4
    [mysqld]
    #默认为3306，此处设置3307端口
    port = 3307
    # 将basedir设置为安装路径
    basedir=E:/mysql-8.0.16-winx64
    # 将datadir设置为数据目录的位置
    datadir=F:/important/MysqlDataStorage
    # 允许最大连接数
    max_connections=200
    # 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
    max_connect_errors=20
    # 服务端使用的字符集默认为8比特编码的latin1字符集
    character-set-server=utf8mb4
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    # 忽略密码
    # skip-grant-tables

** 2. 根据配置的datadir创建相应的文件夹（F:\\important\\MysqlDataStorage）**

![20190630161854193.png][]

### 三、环境变量配置 ###

**删除老版本mysql的环境变量配置，添加mysql8.0.16的环境变量配置 **

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 1][]

###  四、执行命令 ###

**1. 以管理员权限打开cmd命令黑窗口**

![20190630175824905.png][]

**2. 定位到mysql安装目录下的bin目录后，执行初始化命令**

mysqld --initialize --console

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 2][]

**3. 以上命令执行成功后， 数据目录位置会自动生成这样一些文件**

![20190630163453472.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 3][]

** 4. 安装mysql服务**

# 安装服务
    mysqld --install mysql_8.0.16
    # 卸载服务
    #mysqld --uninstall mysql_8.0.16
    # 移除服务
    mysqld --remove mysql_8.0.16

![20190630163716876.png][]

** 5. 查看安装的服务**

services.msc

![20190630164103979.png][]

![20190630163915537.png][]

** 6. 启动服务**

net start mysql_8.0.16

![20190630180200809.png][]

![20190630180134624.png][]

**7. 设置密码**

**1.登陆（/,q+piHs:8WH为前面的初始密码）**

mysql -h127.0.0.1 -P3307 -uroot -p/,q+piHs:8WH

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 4][]

**2. 修改密码**

alter user 'root'@'localhost' IDENTIFIED BY '1234';

![201906301823191.png][]

** 3. 刷新结果**

flush privileges;

![20190630182340514.png][]

###  五、测试连接 ###

**通过Navicat Premium 12测试连接**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 5][]

![201906301819339.png][]

**到此mysql配置结束 **

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[https_cdn.mysql.com_Downloads_MySQL-8.0_mysql-8.0.16-winx64.zip]: https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.16-winx64.zip
[2019063016295537.png]: /images/20211219/1b835989ef224e128408e19d14fea33d.png
[20190630161438280.png]: /images/20211219/aa0e4e6f1d6e46c494c910fd1f7c1e35.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70]: /images/20211219/c07563940d9a4602ae252461530f58a7.png
[20190630161854193.png]: /images/20211219/c22120bd274648148f259c5812bb43e3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 1]: /images/20211219/357bdca666e44006a5cf413542891d64.png
[20190630175824905.png]: /images/20211219/4d67d916c7c544f29d6ce9937e2e6713.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 2]: /images/20211219/b84cb5182682473baba702da6976a30e.png
[20190630163453472.png]: /images/20211219/f06d475dbf244e50acc63e042289ba0e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 3]: /images/20211219/53137d00b2fe416294d03e0300939405.png
[20190630163716876.png]: /images/20211219/46e5dbd047d348ada05005eaa5798672.png
[20190630164103979.png]: /images/20211219/6a0da1a9101e452aad85512fe78ea1c3.png
[20190630163915537.png]: /images/20211219/b6c703f6982e4c70a3fd079469cf6a3a.png
[20190630180200809.png]: /images/20211219/bd3becc6c2f64798975932c403ffb37b.png
[20190630180134624.png]: /images/20211219/9310ca425fec4665b0cd988544dd77c4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 4]: /images/20211219/670b1d607b6f43dd867e9587a32f51cc.png
[201906301823191.png]: /images/20211219/ee1ec6e963a64975bb322ebfc54eb3da.png
[20190630182340514.png]: /images/20211219/ddff26ac32c747539f0e5190e8098e8b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 5]: /images/20211219/fca2a90e98f24d4fa9d70d1f3aeb4313.png
[201906301819339.png]: /images/20211219/7be5bb6ee8724f3891ca22eae32bbd60.png