MySQL：windows10安装MYSQL8.0

柔光的暖阳◎ 2022-05-13 13:40 242阅读 0赞

### 文章目录 ###

*  1、下载
 *  2、解压
 *  3、添加环境变量
 *  4、配置MYSQL
 *  5、安装并启动MYSQL服务器
 *  6、登陆并设置初始密码

# 1、下载 #

地址：https://dev.mysql.com/downloads/mysql/  
![在这里插入图片描述][2019012309120861.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]

# 2、解压 #

本人解压路径为：E:\\software\\mysql-8.0.14-winx64  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]

# 3、添加环境变量 #

添加：

*  键名：MYSQL\_HOME
 *  值为：E:\\software\\mysql-8.0.14-winx64  
    ![在这里插入图片描述][20190123091911609.png]  
    ![在这里插入图片描述][20190123091925663.png]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 2]
 *  ![在这里插入图片描述][20190123092138934.png]  
    \*Path中添加：%MYSQL\_HOME%\\bin  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 3]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 4]

# 4、配置MYSQL #

在E:\\software\\mysql-8.0.14-winx64新建一个.ini格式文件my.ini。其中my.ini内容为

[mysqld]
    port=3306
    # 设置mysql的安装目录
    basedir=E:/software/mysql-8.0.14-winx64    -- 根据需要更改,并且路径不能是\,否则会出现找不到路径的错误
    # 设置mysql数据库的数据的存放目录
    datadir=E:/software/mysql-8.0.14-winx64/data  -- 根据需要更改,并且路径不能是\,否则会出现找不到路径的错误
    # 允许最大连接数
    max_connections=200
    # 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
    max_connect_errors=10
    # 服务端使用的字符集默认为utf8mb4
    character-set-server=utf8mb4
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    
    ########log settings######## 
    expire_logs_days = 30 
    log_error = error.log 
    slow_query_log = 1 
    slow_query_log_file = slow.log 
    long_query_time = 2 
    log_timestamps = SYSTEM 
    log_slow_admin_statements = 1  
    log_slow_slave_statements = 1 
    min_examined_row_limit = 1000
    
    [mysql]
    # 设置mysql客户端默认字符集
    default-character-set=utf8mb4

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 5]

# 5、安装并启动MYSQL服务器 #

以管理员身份打开cmd命令提示行，并进入安装目录的bin目录下：cd /d E:\\software\\mysql-8.0.14-winx64\\bin  
![在这里插入图片描述][20190123093810141.png]

*  初始化：mysqld --initialize-insecure并且以执行安装命令mysqld -install【如果已经安装了mysqld，先删除：mysqld -remove MySQL】  
    ![在这里插入图片描述][20190123100922225.png]  
    执行mysqld --initialize-insecure之后E:\\software\\mysql-8.0.14-winx64自动传教了data目录  
    mysqld --initialize-insecure的目录是免密登陆初始化  
    ![在这里插入图片描述][20190123101150478.png]  
    备注：如果不以管理员身份打开cmd命令行，会出现错误：  
    ![在这里插入图片描述][20190123093906516.png]
 *  启动服务器net start mysql  
    ![在这里插入图片描述][20190123101044899.png]

# 6、登陆并设置初始密码 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 6]  
修改密码为123456：ALTER USER root@localhost IDENTIFIED BY ‘123456’;  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 7]  
参考：https://blog.csdn.net/wyxeainn/article/details/75865434  
https://blog.csdn.net/m0\_37788308/article/details/79965378  
https://www.cnblogs.com/tangyb/p/8971658.html

[2019012309120861.png]: /images/20220504/68ba37c68afb44c9b8b1a848823c2a9a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]: /images/20220504/bce27f08f6984329af873de0a10f2f18.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]: /images/20220504/fdf661a38afb41c3b3eb9e019d75d497.png
[20190123091911609.png]: /images/20220504/f63b58c17a1845d6a029e55d6f4d067e.png
[20190123091925663.png]: /images/20220504/d20472297fb64b51ba0446b9866b8ebd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 2]: /images/20220504/9e7e7e9a9d5a4cab8dac553136d046f4.png
[20190123092138934.png]: /images/20220504/c10008cb4606434ca61bde1e60a6808f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 3]: /images/20220504/60c0078a63d74ce5b260e8f82b76bfd5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 4]: /images/20220504/1a40666135704a168d064d774b0c2d24.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 5]: /images/20220504/4fc20b19c1054692bffdaebe0236d42e.png
[20190123093810141.png]: /images/20220504/523a1f6b31e24782a9861ef32ee15eff.png
[20190123100922225.png]: /images/20220504/a4b19032102341c38ea1a4aca8033672.png
[20190123101150478.png]: /images/20220504/cfb19a03dd644cef93ffdd6a706b9e9b.png
[20190123093906516.png]: /images/20220504/1b1a8f0508b54cc8893c0ec8bb72b9c1.png
[20190123101044899.png]: /images/20220504/d1e4b1d83480421a86d8e00e1a355bc5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 6]: /images/20220504/c72836d21b114978a364ad134a56311f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 7]: /images/20220504/5db6a78a0a3446ff85ff153d076510fc.png