Linux下MySQL5.7安装步骤

1、更新软件包列表

apt-get update

2、查看系统默认安装的数据库版本

apt-cache policy mysql-server

3、需要安装mysql5.7的版本就需要换源

养成习惯，先备份文件：

cp /etc/apt/sources.list /etc/apt/sources.list.back

然后更换apt源：修改sources.list文件

vim /etc/apt/sources.list

#  阿里源deb http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiversedeb http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiversedeb http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiversedeb http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiversedeb http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiversedeb-src http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiversedeb-src http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiversedeb-src http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiversedeb-src http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiversedeb-src http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse

更新镜像源

gpg --keyserver keyserver.ubuntu.com --recv 3B4FE6ACC0B21F32gpg --export --armor 3B4FE6ACC0B21F32 | apt-key add -apt-get update

查看默认安装的mysql数据库版本,可以看到默认的已经变成了mysql5.7的版本了

4、安装MySQL并查看是否安装完成（安装过程中需要确认的直接默认点ok进入下一步即可）

apt-get -y install mysql-server-5.7

## 查看mysql是否安装成功

dpkg -l | grep mysql

mysql -V

systemctl status mysql

设置开机自启：

systemctl enable mysql

5、修改服务为全网启动

6、换回apt源

cd /etc/aptmv sources.list sources.list.oldmv sources.list.back  sources.listapt-get update

7、设置允许远程访问

use mysql;update user set host='%' where user = 'root' and host='localhost';grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;flush privileges;