ubuntu16.0.4下安装MySQL

1、下载

sudo wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_8.0.15-1ubuntu16.04_amd64.deb-bundle.tar

 

2、解压

sudo mkdir temp
sudo tar -xvf mysql-server_8.0.15-1ubuntu16.04_amd64.deb-bundle.tar -C ./temp

 

3、安装mysql依赖环境

sudo apt-get -f install
sudo apt-get install libaio1
sudo apt-get install libmecab2
sudo apt-get install libjson-perl
sudo apt-get install libnuma1

 

4、安装

sudo dpkg -i mysql-common_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i libmysqlclient21_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i libmysqlclient-dev_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i mysql-community-client-core_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i mysql-community-client_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i mysql-client_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i mysql-community-server-core_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i mysql-community-server_8.0.15-1ubuntu16.04_amd64.deb
 
sudo dpkg -i mysql-server_8.0.15-1ubuntu16.04_amd64.deb

在执行安装mysql-community-server_8.0.15-1ubuntu16.04_amd64.deb时，会弹出以下输入框，提示输入root账号密码。

 

 输入密码后，当前版本mysql会提示选择mysql授权相关加密方式。选择

 

 5、登录验证

sudo mysql -u root -p

 

 6、开启远程访问

use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;
select host, user from user;