Linux/Ubuntu16.4 安装mysql8.0配置

1.查看mysql 依赖 

dpkg --list|grep mysql

正常Ubnutu16.4安装的mysql依赖为5.7，此次需要安装的版本为8.0需要将依赖升级

2.使用命令下载存储库软件安装包

wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb

3.安装上面下载的软件安装包，会有提示默认选择8.0版本，直接选择"OK就行了"

sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

4.安装完成后需要更新apt存储库，使apt找那个有最新软件包信息

sudo apt update

       4.1  安装过程会出现签名无效

Err:13 http://repo.mysql.com/apt/ubuntu xenial InRelease                                                  
  The following signatures were invalid: KEYEXPIRED 1550412832  KEYEXPIRED 1550412832  KEYEXPIRED 1550412832
Reading package lists... Done                                                                             
W: GPG error: http://repo.mysql.com/apt/ubuntu xenial InRelease: The following signatures were invalid: KEYEXPIRED 1550412832  KEYEXPIRED 1550412832  KEYEXPIRED 1550412832
E: The repository 'http://repo.mysql.com/apt/ubuntu xenial InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.

      解决方法重新添加签名代码：

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8C718D3B5072E1F5

     4.2 安装过程中出现报错

Reading package lists... Done
E: Problem executing scripts APT::Update::Post-Invoke-Success 'if /usr/bin/test -w /var/cache/app-info -a -e /usr/bin/appstreamcli; then appstreamcli refresh > /dev/null; fi'
E: Sub-process returned an error code

       解决方法

sudo pkill -KILL appstreamcli

wget -P /tmp https://launchpad.net/ubuntu/+archive/primary/+files/appstream_0.9.4-1ubuntu1_amd64.deb https://launchpad.net/ubuntu/+archive/primary/+files/libappstream3_0.9.4-1ubuntu1_amd64.deb

sudo dpkg -i /tmp/appstream_0.9.4-1ubuntu1_amd64.deb /tmp/libappstream3_0.9.4-1ubuntu1_amd64.deb

5安装mysql8.0版本 

sudo apt install mysql-server

此处为下载需要的资源可能因为链接不稳定下载失败，重新执行上面命令或者切换下载路由即可

完成后需要设置mysql密码进入

输入之后会出现选择加密方式的提示界面，默认的mysql8.0的加密方式与ubuntu18.04 不兼容，所以选择5.x的加密方式；如无必要建议不需要选上面；

上述mysql8.0就安装好了

6.查看版本和登录检验

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