Ubuntu16.04 deb安装 mysql 5.7.30（无网络情况）

水深无声 2023-02-11 04:36 105阅读 0赞

## 前期准备： ##

> 依赖包查询地址：[https://pkgs.org/][https_pkgs.org]  （在搜索框中搜索所需要的deb包）
> 
> 或者直接从这个地址下载全部依赖：[https://download.csdn.net/download/chw0629/12447887][https_download.csdn.net_download_chw0629_12447887]

首先下载mysql包：

64位：[https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-server\_5.7.30-1ubuntu16.04\_amd64.deb-bundle.tar][https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-server_5.7.30-1ubuntu16.04_amd64.deb-bundle.tar]

32位：[https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-server\_5.7.30-1ubuntu16.04\_i386.deb-bundle.tar][https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-server_5.7.30-1ubuntu16.04_i386.deb-bundle.tar]

\-------全部相关依赖包可以[点击这里][https_download.csdn.net_download_chw0629_12447887]下载----------

依赖包libmecab2：

64位：[http://archive.ubuntu.com/ubuntu/pool/universe/m/mecab/libmecab2\_0.996-1.2ubuntu1\_amd64.deb][http_archive.ubuntu.com_ubuntu_pool_universe_m_mecab_libmecab2_0.996-1.2ubuntu1_amd64.deb]

32位：[http://archive.ubuntu.com/ubuntu/pool/universe/m/mecab/libmecab2\_0.996-1.2ubuntu1\_i386.deb][http_archive.ubuntu.com_ubuntu_pool_universe_m_mecab_libmecab2_0.996-1.2ubuntu1_i386.deb]

依赖包libaio1：

64位：[http://archive.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio1\_0.3.110-2\_amd64.deb][http_archive.ubuntu.com_ubuntu_pool_main_liba_libaio_libaio1_0.3.110-2_amd64.deb]

32位：[http://archive.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio1\_0.3.110-2\_i386.deb][http_archive.ubuntu.com_ubuntu_pool_main_liba_libaio_libaio1_0.3.110-2_i386.deb]

## 安装mysql： ##

> *1> tar xvf mysql-server\_5.7.30-1ubuntu16.04\_amd64.deb-bundle.tar*

![format_png][]

所需的deb包

> *2> sudo dpkg -i libaio1\_0.3.110-2\_amd64.deb*

![format_png 1][]

libaio1 依赖包安装

> *3> sudo dpkg-preconfigure mysql-community-server\_\*.deb*

需要设置root用户的密码（建议大写字母+小写字母+特殊字符）

![format_png 2][]

输入密码

![format_png 3][]

再次输入密码

> *4> sudo dpkg -i mysql-common\_\*.deb*

![format_png 4][]

mysql基础包

> *5> sudo dpkg -i mysql-community-client\_\*.deb*

![format_png 5][]

mysql-community-client安装

> *6> sudo dpkg -i mysql-client\_\*.deb*

![format_png 6][]

mysql-clien 安装

> *7> sudo dpkg -i mysql-community-server\_\*.deb*

如果报一下错误，需要安装依赖包：

![format_png 7][]

依赖报错

> *7.1> sudo dpkg -i libmecab2\_0.996-1.2ubuntu1\_amd64.deb*

![format_png 8][]

libmecab2依赖包安装

> *7.2> sudo dpkg -i mysql-community-server\_\*.deb*

![format_png 9][]

mysql server安装

## 配置远程登录： ##

> *1> mysql -uroot –p\{密码是前面设置的\}*

> *2> grant all privileges on \*.\* to 'root'@'%'identified by '密码' with grant option;*

> *3> exit;*

> *4> cd /etc/mysql/mysql.conf.d*

> *5> sudo vi mysqld.cnf*

注释bind-address = 127.0.0.1

![format_png 10][]

配置文件

> *6> systemctl restart mysql.service*

[https_pkgs.org]: https://pkgs.org/
[https_download.csdn.net_download_chw0629_12447887]: https://download.csdn.net/download/chw0629/12447887
[https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-server_5.7.30-1ubuntu16.04_amd64.deb-bundle.tar]: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-server_5.7.30-1ubuntu16.04_amd64.deb-bundle.tar
[https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-server_5.7.30-1ubuntu16.04_i386.deb-bundle.tar]: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-server_5.7.30-1ubuntu16.04_i386.deb-bundle.tar
[http_archive.ubuntu.com_ubuntu_pool_universe_m_mecab_libmecab2_0.996-1.2ubuntu1_amd64.deb]: http://archive.ubuntu.com/ubuntu/pool/universe/m/mecab/libmecab2_0.996-1.2ubuntu1_amd64.deb
[http_archive.ubuntu.com_ubuntu_pool_universe_m_mecab_libmecab2_0.996-1.2ubuntu1_i386.deb]: http://archive.ubuntu.com/ubuntu/pool/universe/m/mecab/libmecab2_0.996-1.2ubuntu1_i386.deb
[http_archive.ubuntu.com_ubuntu_pool_main_liba_libaio_libaio1_0.3.110-2_amd64.deb]: http://archive.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio1_0.3.110-2_amd64.deb
[http_archive.ubuntu.com_ubuntu_pool_main_liba_libaio_libaio1_0.3.110-2_i386.deb]: http://archive.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio1_0.3.110-2_i386.deb
[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LWI1OWE2ZmU1MjkyYmYwMjQucG5n?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LTI5NzA3NzNkZGUyOWI0Y2QucG5n?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LTAzMjM4NzY2OTkyNTVlYmIucG5n?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LWI4YmJlOWVmMzk4ZjA4ZDcucG5n?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LTQxNDk4ODljYmNjZDdmN2UucG5n?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LTBkYjc4MjJmYTg5MGVlODcucG5n?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LTcyMmJlNjAzYTY4N2JhNTYucG5n?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LWM2YzQwY2E4NGM4MjQxMGYucG5n?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LWYyYjcxOTZkMzU2MDZjMjgucG5n?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LTM1NDUxMjAxODEyYWZhOGYucG5n?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy80ODUzODA2LWJiNjZlOTQzODZiMDNiN2MucG5n?x-oss-process=image/format,png