Ubuntu 16.04离线安装MySQL 5.7.24

于MySQL官网：https://dev.mysql.com/downloads/mysql/5.7.html
下载mysql-server_5.7.24-1ubuntu16.04_amd64.deb-bundle.tar至Downloads目录

更新软件源

sudo apt-get update

安装依赖

以下依赖根据实际情况选择安装，若于安装数据库时，提示缺少依赖，再行安装依赖。

# apt-cache search libaio
# sudo apt-get install libaio1

查找依赖库版本

apt-cache search libmecab

安装对应版本依赖库

sudo apt-get install libmecab2

展开Debian捆绑包

创建mysql目录

mkdir /usr/local/mysql

进入Downloads目录

cd /root/Downloads/

移动捆绑包至mysql目录

mv mysql-server_5.7.24-1ubuntu16.04_amd64.deb-bundle.tar /usr/local/mysql/

切换至mysql目录

cd /usr/local/mysql/

解压捆绑包

tar -xvf mysql-server_5.7.24-1ubuntu16.04_amd64.deb-bundle.tar

解压之后出现一系列.deb文件

libmysqlclient20_5.7.24-1ubuntu16.04_amd64.deb
libmysqlclient-dev_5.7.24-1ubuntu16.04_amd64.deb
libmysqld-dev_5.7.24-1ubuntu16.04_amd64.deb
mysql-client_5.7.24-1ubuntu16.04_amd64.deb
mysql-common_5.7.24-1ubuntu16.04_amd64.deb
mysql-community-client_5.7.24-1ubuntu16.04_amd64.deb
mysql-community-server_5.7.24-1ubuntu16.04_amd64.deb
mysql-community-source_5.7.24-1ubuntu16.04_amd64.deb
mysql-community-test_5.7.24-1ubuntu16.04_amd64.deb
mysql-server_5.7.24-1ubuntu16.04_amd64.deb
mysql-testsuite_5.7.24-1ubuntu16.04_amd64.deb

安装数据库

预配置

按要求设置root密码

sudo dpkg-preconfigure mysql-community-server_5.7.24-1ubuntu16.04_amd64.deb

应用Debian包

捆绑包解压所得.deb文件存在依赖关系，需要按照一定顺序进行安装。
有两种安装方式：
第一种：多个顺序安装

sudo dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb

第二种：单个顺序安装
mysql-community-server依赖于libmecab2

sudo dpkg -i libmysqlclient20_5.7.24-1ubuntu16.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.24-1ubuntu16.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.24-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-common_5.7.24-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.24-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-client_5.7.24-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-community-server_5.7.24-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-server_5.7.24-1ubuntu16.04_amd64.deb

If you are being warned of unmet dependencies by dpkg, you can fix them using apt-get
sudo apt-get -f install xxx

安装文件的位置

All configuration files (like my.cnf) are under /etc/mysql
All binaries, libraries, headers, etc., are under /usr/bin and /usr/sbin
The data directory is /var/lib/mysql