虚拟机实操-ubuntu离线安装mysql

ubuntu版本：18.04

 

mysql版本：mysql-server_5.7.30

 

 

将下载下来的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;