Ubuntu20安装MySQL5.7

下载安装包

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-server_5.7.32-1ubuntu18.04_amd64.deb-bundle.tar

解压压缩包

tar -xvf mysql-server_5.7.32-1ubuntu18.04_amd64.deb-bundle.tar

安装MySQL

sudo dpkg -i mysql-common_5.7.32-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.32-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.32-1ubuntu18.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.32-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.32-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-client_5.7.32-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-community-source_5.7.32-1ubuntu18.04_amd64.deb
sudo dpkg -i mysql-community-server_5.7.32-1ubuntu18.04_amd64.deb

遇到的问题：

dpkg: error processing package XXX (--configure)

解决方案：

sudo apt-get update
sudo apt-get upgrade

修改MySQL配置

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
# 注释掉这行配置
# bind-address  = 127.0.0.1

进入MySQL

mysql -uroot -p

遇到的问题：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

解决方案：

sudo touch /var/run/mysqld/mysqld.sock
sudo chmod 777 /var/run/mysqld/mysqld.sock
sudo /etc/init.d/mysql restart

MySQL的安装目录：

/etc/mysql/

MySQL的插件目录：

# 可以在MySQL中执行 show global variables like 'plugin_dir';  获取
/usr/lib/mysql/plugin/

MySQL5.7安装审计插件
链接地址