【MySQL】windows10下安装使用MySQL8.0

Love The Way You Lie 2022-12-23 03:27 171阅读 0赞

### 文章目录 ###

*   *   *   *  前言
             *  下载MySQL
             *  创建目录和文件
             *  配置环境变量
             *  启动MySQL
             *   *  1. 切换到bin目录下
                 *  2. 删除原有的MySQL
                 *  3. 安装MySQL
                 *  4. MySQL初始化
                 *  5. 启动MySQL
                 *  6. 登陆MySQL
                 *  7. 修改初始密码
             *  常用命令
             *  设置开机启动
             *  总结

#### 前言 ####

有时候懒得打开vmware，但是还想使用MySQL，除了买阿里云服务器外，最好的办法就是在windows上直接部署一个MySQL设置开机启动。  
只要开机既可以登陆MySQL，免去了打开vmware的麻烦，真是懒人必备。

#### 下载MySQL ####

下载windwos版本的MySQL  
此处下载的是免安装版  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 1]

#### 创建目录和文件 ####

在解压路径创建data目录和my.ini文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 2]  
在my.ini里指定路径：

[mysqld]
    # 设置3306端口
    port=3306
    # 设置mysql的安装目录
    basedir=D:/RJ-CY
    # 设置mysql数据库的数据的存放目录
    datadir=D:/RJ-CY/data
    # 允许最大连接数
    max_connections=200
    # 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
    max_connect_errors=10
    # 服务端使用的字符集默认为UTF8
    character-set-server=utf8
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    [mysql]
    # 设置mysql客户端默认字符集
    default-character-set=utf8
    [client]
    # 设置mysql客户端连接服务端时默认使用的端口
    port=3306
    default-character-set=utf8

#### 配置环境变量 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 4]  
新建MYSQL\_HOME系统变量  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 5]

![在这里插入图片描述][20201122115614390.png_pic_center]  
修改path变量  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 6]

#### 启动MySQL ####

##### 1. 切换到bin目录下 #####

![在这里插入图片描述][20201122121438676.png_pic_center]

##### 2. 删除原有的MySQL #####

mysqld --removed

##### 3. 安装MySQL #####

mysqld --install

##### 4. MySQL初始化 #####

D:\RJ-CY\bin>mysqld --initialize --user=mysql --console
    2020-11-22T03:46:54.724941Z 0 [System] [MY-013169] [Server] D:\RJ-CY\bin\mysqld.exe (mysqld 8.0.22) initializing of server in progress as process 19080
    2020-11-22T03:46:54.726169Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
    2020-11-22T03:46:54.743202Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
    2020-11-22T03:46:55.913943Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
    2020-11-22T03:46:57.893274Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: hasJjldQ5N<g

##### 5. 启动MySQL #####

D:\RJ-CY\bin>net start mysql
    MySQL 服务正在启动 .
    MySQL 服务已经启动成功。

##### 6. 登陆MySQL #####

D:\RJ-CY\bin>mysql -u root -p
    Enter password: ************
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 10
    Server version: 8.0.22
    
    Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

##### 7. 修改初始密码 #####

mysql> ALTER USER root@localhost IDENTIFIED BY 'xxXXX123!';
    Query OK, 0 rows affected (0.02 sec)

#### 常用命令 ####

*  切换路径： cd
 *  查看路径下的文件 ： dir
 *  安装MySQL： mysql --install
 *  删除MySQL： mysqld --remove
 *  MySQL 初始化： mysqld --initalize --user=mysql --console
 *  启动MySQL： net start mysql
 *  登陆MySQL: mysql -u root -p
 *  修改初始密码: ALTER USER root@localhost IDENTIFIED BY ‘xxXXX123!’;

#### 设置开机启动 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 8]  
![在这里插入图片描述][2020112212254237.png_pic_center]

#### 总结 ####

好了现在可以愉快的使用MySQL8了，不用总开虚拟机了。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/421adc0330c84b3495883c4395b7f83c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/20201122105542183.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 2]: https://img-blog.csdnimg.cn/20201122115402657.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 3]: https://img-blog.csdnimg.cn/20201122115456396.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 4]: https://img-blog.csdnimg.cn/20201122115520475.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 5]: https://img-blog.csdnimg.cn/20201122115559607.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[20201122115614390.png_pic_center]: https://img-blog.csdnimg.cn/20201122115614390.png#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 6]: https://img-blog.csdnimg.cn/20201122111235727.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[20201122121438676.png_pic_center]: https://img-blog.csdnimg.cn/20201122121438676.png#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 7]: https://img-blog.csdnimg.cn/20201122122426321.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4_size_16_color_FFFFFF_t_70_pic_center 8]: https://img-blog.csdnimg.cn/20201122122458127.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpbnNodXpoYW4=,size_16,color_FFFFFF,t_70#pic_center
[2020112212254237.png_pic_center]: https://img-blog.csdnimg.cn/2020112212254237.png#pic_center