解压版MySQL安装与卸载教程

深碍√TFBOYSˉ_ 2022-10-15 11:55 212阅读 0赞

MySQL分为安装版和解压版。安装版经常安装失败，重新安装需要卸载MySQL，十分麻烦，推荐解压版MySQL。

详细步骤如下：

## 1.下载 ##

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

根据你的系统（32位或者64位）选择后缀是ZIP Archive的压缩包下载到本地，这里我下载的是“**MySQL5.7.13**”

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70][]

点击Dowload后会要求你登录，不用管，直接点击No thanks, just start my download。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 1][]

## 2.解压 ##

MySQL5.7.13的解压后的内容如下，解压后将文件重命名为MySQL，放在D\\software目录下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 2][]

## 3.配置my.ini ##

此时根目录下只有一个my-default.ini文件 ，直接复制my-default.ini，重命名为my.ini，再对my.ini进行修改。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 3][]

原始的my.ini为：

# For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
    # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
    # *** default location during install, and will be replaced if you
    # *** upgrade to a newer version of MySQL.
    
    
    [mysqld]
    
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    
    # These are commonly set, remove the # and set as required.
    # basedir = .....
    # datadir = .....
    # port = .....
    # server_id = .....
    
    
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M 
    
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

修改后的内容为：

# For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
    # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
    # *** default location during install, and will be replaced if you
    # *** upgrade to a newer version of MySQL.
    
    [mysql]
     default-character-set = utf8
    
    [mysqld]
    
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    
    # These are commonly set, remove the # and set as required.
    basedir = D:\\software\\MySQL
    datadir = D:\\software\\MySQL\\data
    port = 3306
    # server_id = .....
    
    
    max_connections=200
    character-set-server=utf8
    default_authentication_plugin=mysql_native_password
    default-storage-engine=INNODB
    wait_timeout=31536000
    interactive_timeout=31536000
    
    
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M 
    
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

解释说明：

[mysql]
    #设置mysql客户端默认字符集
    default-character-set=utf8
    
    [mysqld]
    #设置3306端口
    port=3306
    #设置mysql的安装目录
    basedir = D:\\software\\MySQL
    #设置mysql数据库的数据的存放目录
    datadir = D:\\software\\MySQL\\data
    
    #允许最大连接数
    max_connections=200
    #服务端使用的字符集默认为8比特编码的latin1字符集
    character-set-server=utf8
    #更改8.0默认的身份认证
    default_authentication_plugin=mysql_native_password
    #创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    wait_timeout=31536000
    interactive_timeout=31536000

**注意： 这里的路径是双下划线“\\\\”，否则在后面安装时会报错**

**    basedir = D:\\\\software\\\\MySQL**

**   datadir = D:\\\\software\\\\MySQL\\\\data**

## 4.配置环境变量。 ##

右键计算机–属性–高级系统设置–环境变量，在系统变量中新建“MYSQL\_HOME”，值为“D:\\software\\MySQL”。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 4][]

在系统变量中找到Path编辑，追加“”。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 5][]

## 5.初始化。 ##

以管理员身份运行cmd

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 6][]

首先切换到**D:\\software\\MySQL\\bin**目录下：

d:
    cd D:\software\MySQL\bin

![20210525090754865.png][]

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

mysqld --initialize-insecure

回车，稍微等待一会，如果出现没有出现报错信息(如下图)则证明data目录初始化没有问题，此时再查看MySQL目录下已经有data目录生成。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 8][]

## 6.注册MySQL服务 ##

继续在上面的黑框里，敲入`mysqld -install`，回车。

![20210525093626519.png][]

## 7.启动MySQL服务 ##

关闭cmd窗口，重新打开一个新的，使用管理员运行cmd。

输入如下内容，回车。

net start mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 9][]

## 8.修改默认账户密码 ##

在黑框里敲入`mysqladmin -u root password root`，这里的`root`就是指默认管理员(即root账户)的密码，可以自行修改成你喜欢的。

![20210525094258979.png][]

**至此，MySQL 5.7 解压版安装完毕！**

--------------------

## 9.登录MySQL ##

关闭所有的cmd窗口，重新运行cmd（不用使用管理员运行）

在黑框中输入，`mysql -uroot -proot`，回车，出现下图且左下角为`mysql>`，则登录成功。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 10][]

**到这里你就可以开始你的MySQL之旅了！**

--------------------

## 10.卸载MySQL ##

如果你想卸载MySQL，也很简单。

使用管理员运行cmd，打开黑框。

敲入`net stop mysql`，回车。

![20210525094858443.png][]

再敲入`mysqld -remove mysql`，回车。

![20210525094916421.png][]

最后删除MySQL目录及相关的环境变量。

**至此，MySQL卸载完成！**

**参考：**

[https://www.cnblogs.com/horvey/p/10151706.html][https_www.cnblogs.com_horvey_p_10151706.html]

[https://blog.csdn.net/salted\_\_\_fish/article/details/106356078][https_blog.csdn.net_salted_fish_article_details_106356078]

[https://www.jb51.net/article/170127.htm][https_www.jb51.net_article_170127.htm]

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70]: /images/20221014/1bcb314763324f848aebb6cfd8159942.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 1]: /images/20221014/484955b905624203b01dd1ffecffd866.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 2]: /images/20221014/a9ca19ee85794a2d9e80167817a7864a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 3]: /images/20221014/57f9ebac21f9483c95ad7f5811b60cd6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 4]: /images/20221014/96e673e6d2e044ddb04fdc77e2e854c0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 5]: /images/20221014/a9e5334fba83460e8b64cfe7ed011440.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 6]: /images/20221014/626d5856a3d44fc9acfd014601d10e60.png
[20210525090754865.png]: /images/20221014/2909f4336ca74be18c8309d6c9d95723.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 7]: /images/20221014/16902ecc9c794a48b8a9bc89fde31d42.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 8]: /images/20221014/2150c1d3e1de449ebc179d6d88e8e7a2.png
[20210525093626519.png]: /images/20221014/dcfac6555c8a423187b6438dc4b86eae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 9]: /images/20221014/1909fdccfb1a4a128695df261093b0ed.png
[20210525094258979.png]: /images/20221014/6001d9bcdd784a7ba2bd3ebeff5d97d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3podWlxaXV6aHVveXVlNTgz_size_16_color_FFFFFF_t_70 10]: /images/20221014/f232aad7bb4b49aba0d1ad417552d2b8.png
[20210525094858443.png]: /images/20221014/8f64cc4595e6464a94f898828f43c00a.png
[20210525094916421.png]: /images/20221014/8f76f5dcb81441d88104958618399be6.png
[https_www.cnblogs.com_horvey_p_10151706.html]: https://www.cnblogs.com/horvey/p/10151706.html
[https_blog.csdn.net_salted_fish_article_details_106356078]: https://blog.csdn.net/salted___fish/article/details/106356078
[https_www.jb51.net_article_170127.htm]: https://www.jb51.net/article/170127.htm