环境

ubuntu18.04
mysql5.7.20的tar格式安装包

下载安装包并解压

官网：https://dev.mysql.com/downloads/mysql/

下载后将安装包放入/usr/server

赋予可执行权限

sudo chmod +x mysql5.7.20.tar.gz

解压：

tar -xf mysql5.7.20.tar.gz

解压后ls查看有如下文件：

libmysqlclient20_5.7.10-1ubuntu14.04_amd64.deb
 
libmysqlclient-dev_5.7.20-1ubuntu14.04_amd64.deb
libmysqld-dev_5.7.20-1ubuntu14.04_amd64.deb
mysql-client_5.7.20-1ubuntu14.04_amd64.deb
mysql-common_5.7.20-1ubuntu14.04_amd64.deb
mysql-community-client_5.7.20-1ubuntu14.04_amd64.deb
mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb
mysql-community-source_5.7.20-1ubuntu14.04_amd64.deb
mysql-community-test_5.7.20-1ubuntu14.04_amd64.deb
mysql-server_5.7.20-1ubuntu14.04_amd64.deb
mysql-testsuite_5.7.20-1ubuntu14.04_amd64.deb
mysql-community_5.7.20-1ubuntu14.04_amd64.changes

更新安装源并安装libaio1依赖：

sudo apt-get update
sudo apt-get upgrade
 
apt-get install libaio1

正式安装：

sudo dpkg -i mysql-common_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg-preconfigure mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb

# 输入两次root用户的密码

sudo dpkg -i libmysqlclient20_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-client_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-common_5.7.20-1ubuntu14.04_amd64.deb

sudo dpkg -i mysql-common_5.7.28-1ubuntu18.04_amd64.deb
sudo dpkg-preconfigure mysql-community-server_5.7.28-1ubuntu18.04_amd64.deb

# 输入两次root用户的密码

sudo dpkg -i libmysqlclient20_5.7.28-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.28-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.28-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.28-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-client_5.7.28-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-common_5.7.28-1ubuntu18.04_amd64.deb

安装依赖包：

sudo apt-get -f install
sudo apt-get -f install libmecab2

安装mysql-server

sudo dpkg -i mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-server_5.7.20-1ubuntu14.04_amd64.deb

sudo dpkg -i mysql-community-server_5.7.28-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-server_5.7.28-1ubuntu18.04_amd64.deb

验证安装：

mysql -u root -p

登录成功即可验证安装成功

打开远程访问权限：

mysql -u root -p
password
use mysql;
GRANT ALL ON *.* TO 'root'@'%'  IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
exit

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
#bind 127.0.0.1  （加 井号 注释掉这一行）

service mysql restart

优化mysql配置：

[mysqld]
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
datadir		= /var/lib/mysql
log-error	= /var/log/mysql/error.log

# By default we only accept connections from localhost
#bind-address	= 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

max_allowed_packet = 524288000
back_log = 400
innodb_thread_concurrency = 16
innodb_buffer_pool_size = 28G
thread_cache_size = 64
innodb_log_file_size = 8G
innodb_log_buffer_size = 64M
innodb_flush_method = O_DIRECT
table_open_cache = 1000
max_connections = 2000
innodb_flush_log_at_trx_commit=1
innodb_autoextend_increment=256M
transaction_isolation=READ-COMMITTED
default-time-zone = '+08:00'