ubuntu 20.04 安装mysql 5.7

ubuntu 20.04 安装mysql 5.7

https://dev.mysql.com/downloads/mysql/5.7.html 选择ubuntu18的64位的tar包
mysql 5.7安装包

进入安装目录，依次执行以下命令

sudo dpkg -i mysql-common_5.7.34-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.34-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.34-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.34-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.34-1ubuntu18.04_amd64.deb
sudo wget http://security.ubuntu.com/ubuntu/pool/universe/m/mecab/libmecab2_0.996-1.2ubuntu1_amd64.deb
sudo dpkg -i libmecab2_0.996-1.2ubuntu1_amd64.deb
sudo dpkg -i mysql-community-client_5.7.34-1ubuntu18.04_amd64.deb
sudo apt install libtinfo5
sudo dpkg -i mysql-client_5.7.34-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-community-server_5.7.34-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-server_5.7.34-1ubuntu18.04_amd64.deb

安装完成后，再修改配置文件，修改不区分大小写，可远程访问。

cd /etc/mysql/mysql.conf.d
sudo gedit mysqld.cnf
#修改以下文件
lower_case_table_names = 1
bind-address	= 0.0.0.0
#重启服务即可
service mysql restart