ubuntu使用deb离线安装mysql

ubuntu版本：18.04

mysql版本：mysql-server_5.7.30

下载地址：https://download.csdn.net/download/muguku/12914120

----------------------

将下载下来的deb包上传到服务器到/opt下

按以下顺序安装

dpkg -i libaio1_0.3.112-3_amd64.deb 

dpkg -i libmecab2_0.996-6_amd64.deb

dpkg -i mysql-common_5.7.30-1ubuntu18.04_amd64.deb

dpkg -i libmysqlclient20_5.7.30-1ubuntu18.04_amd64.deb

dpkg -i libmysqlclient-dev_5.7.30-1ubuntu18.04_amd64.deb

dpkg -i libmysqld-dev_5.7.30-1ubuntu18.04_amd64.deb 

dpkg -i mysql-community-client_5.7.30-1ubuntu18.04_amd64.deb 

dpkg -i mysql-client_5.7.30-1ubuntu18.04_amd64.deb

dpkg -i mysql-community-source_5.7.30-1ubuntu18.04_amd64.deb 

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

dpkg -i mysql-server_5.7.30-1ubuntu18.04_amd64.deb

查看mysql是否运行

service mysql  status

远程登陆赋权

vi /etc/mysql/mysql.conf.d/mysqld.cnf 

重启mysql：service mysql restart

mysql -u root -p

use mysql

update user set host='%' where user='root'

flush privileges;