Ubuntu下升级Mysql全过程（亲测）

客官°小女子只卖身不卖艺 2022-10-05 12:58 231阅读 0赞

### 文章目录 ###

*   *   *  0、测试环境状态
         *  1、下载mysql的apt的源
         *  2、升级

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

### 0、测试环境状态 ###

> 环境：  
> Ubuntu 18.04.1 LTS  
> mysql 5.7（初次安装，没有数据）

目标：将mysql升级到8.0；不考虑数据问题；

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

### 1、下载mysql的apt的源 ###

[https://dev.mysql.com/downloads/][https_dev.mysql.com_downloads]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70]  
将下载的mysql-apt-config\_0.8.15-1\_all.deb文件复制到服务器；

### 2、升级 ###

dpkg -i mysql-apt-config_0.8.15-1_all.deb

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70 3]

Configuration file '/etc/mysql/mysql.conf.d/mysqld.cnf'
     ==> Modified (by you or by a script) since installation.
     ==> Package distributor has shipped an updated version.
       What would you like to do about it ?  Your options are:
        Y or I  : install the package maintainer's version
        N or O  : keep your currently-installed version
          D     : show the differences between the versions
          Z     : start a shell to examine the situation
     The default action is to keep your current version.
    *** mysqld.cnf (Y/I/N/O/D/Z) [default=N] ? Y

apt update
    apt install mysql-server

查看版本

mysql -V
    mysql  Ver 8.0.25 for Linux on x86_64 (MySQL Community Server - GPL)

Mysql已成功升级！

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

[https_dev.mysql.com_downloads]: https://dev.mysql.com/downloads/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70]: /images/20221005/1331d07abb13468eb8bcecdeca24ab2f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70 1]: /images/20221005/e8df765b178f47c5bb3273492aef5242.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70 2]: /images/20221005/9e3a7520668c4ae2bb97328b1e7c43ec.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpbmd0b2xvdmU_size_16_color_FFFFFF_t_70 3]: /images/20221005/7c8e5a9ff98d454593087248c6b02064.png