如何升级到MySQL 8.0？

Question

我有一个带有MySQL 5.7.25的Ubuntu服务器18.04上的Drupal站点8.6.10

我想把MySQL更新到8.0版

Here是我遵循的步骤:

1)我备份了数据库。

2)使用以下命令从服务器卸载MySQL：

$ sudo systemctl stop mysql
$ sudo apt remove mysql-*
$ sudo apt purge mysql-*
$ sudo apt autoremove
$ sudo dpkg -l | grep mysql | grep ii

3)我使用命令添加了存储库：

$ wget https://repo.mysql.com//mysql-apt-config_0.8.12-1_all.deb

4)我使用以下命令安装了包：

$ sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb

在这里输入图像描述

My问题:

5)我使用以下命令安装MySQL：

$ sudo apt update
$ sudo apt install mysql-server

当我执行第5步时，它安装MySQL 5.7为什么不安装版本8？

在这里输入图像描述

Answer 1

嗯，我在一台测试机器中尝试了上面的内容，而且看起来好像mysql存储库中出现了故障。

具体来说，密钥似乎过期了。

# apt-key list       
/etc/apt/trusted.gpg
--------------------
pub   dsa1024 2003-02-03 [SCA] [expired: 2019-02-17]
      A4A9 4068 76FC BD3C 4567  70C8 8C71 8D3B 5072 E1F5
uid           [ expired] MySQL Release Engineering 

如果您真的想忽略这些错误并安装，您可以像下面这样调整您的mysql.list。请记住，这可能会打开您对某人mitm包的下载。

### THIS FILE IS AUTOMATICALLY CONFIGURED ###
# You may comment out entries below, but any other modifications may be lost.
# Use command 'dpkg-reconfigure mysql-apt-config' as root for modifications.
deb [trusted=yes] http://repo.mysql.com/apt/ubuntu/ bionic mysql-apt-config
deb [trusted=yes] http://repo.mysql.com/apt/ubuntu/ bionic mysql-8.0
deb [trusted=yes] http://repo.mysql.com/apt/ubuntu/ bionic mysql-tools
#deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-tools-preview
deb-src [trusted=yes] http://repo.mysql.com/apt/ubuntu/ bionic mysql-8.0

无论如何，如果您走这个路线，那么您还需要知道包的名称似乎像mysql-community-*用于这个回购中的8.0包。

# apt-cache policy mysql-community-server
mysql-community-server:
  Installed: (none)
  Candidate: 8.0.15-1ubuntu18.04
  Version table:
     8.0.15-1ubuntu18.04 500
        500 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 Packages


# apt-cache policy mysql-community-server
mysql-community-server:
  Installed: (none)
  Candidate: 8.0.15-1ubuntu18.04
  Version table:
     8.0.15-1ubuntu18.04 500
        500 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 Packages
root@01d5a926dd00:/etc/apt/sources.list.d# apt-cache show mysql-community-server
Package: mysql-community-server
Source: mysql-community
Version: 8.0.15-1ubuntu18.04
Architecture: amd64
Maintainer: MySQL Release Engineering 
...
Provides: virtual-mysql-server
Homepage: http://www.mysql.com/
Priority: optional
Section: database
Filename: pool/mysql-8.0/m/mysql-community/mysql-community-server_8.0.15-1ubuntu18.04_amd64.deb
Description: MySQL Server
 The MySQL(TM) software delivers a very fast, multi-threaded, multi-user,
 and robust SQL (Structured Query Language) database server. MySQL Server
 is intended for mission-critical, heavy-load production systems as well
 as for embedding into mass-deployed software. MySQL is a trademark of
 Oracle. This package includes the MySQL server binary as well as related
 utilities to run and administer a MySQL server.

Answer 2

我也有过类似的问题&通过

sudo apt-get purge mysql\* libmysql\*

并遵循本教程https://computingforgeeks.com/how-to-install-mysql-8-on-ubuntu/