记ubuntu安装MySQL
版本
ubuntu版本 :Ubuntu Server 20.04 LTS 64bit;MySQL:5.7
如已安装了MySQL先将其卸载,参考:Ubuntu18.04彻底删除MySQL数据库
安装MySQL5.7
使用的为腾讯云服务器,源为腾讯云的源,默认安装的MySQL版本为8.0,现在需要安装5.7版本
1.添加镜像源
sudo vim /etc/apt/sources.list
# 清华镜像源
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial main restricted universe multiverse
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial-updates main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial-updates main restricted universe multiverse
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial-backports main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial-backports main restricted universe multiverse
deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial-security main restricted universe multiverse
deb-src https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ xenial-security main restricted universe multiverse
- 更新镜像源
sudo apt-get update
sudo apt-get upgrade
3.安装MySQL
sudo apt-get install mysql-server-5.7
安装过程中会提示设置root的密码,进行设置即可
安装完成后,本地使用navicat连接
发现会出现连接不上的问题
修改 /etc/mysql/mysql.conf文件,将图中bind-address屏蔽掉
重启MySQL服务
sudo service mysql restart