Ubuntu下MySQL5.7安装步骤

原创于 2026-07-01 11:37:13 发布 · 226 阅读

5 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

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 multiverse``deb http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse``deb http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse``deb http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse``deb http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse``deb-src http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse``deb-src http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse``deb-src http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse``deb-src http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse``deb-src http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse

更新镜像源

gpg --keyserver keyserver.ubuntu.com --recv 3B4FE6ACC0B21F32``gpg --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/apt``mv sources.list sources.list.old``mv sources.list.back sources.list``apt-get update

7**、设置允许远程访问**

use mysql;
update user set host='%' where user = 'root' and host='localhost';
-- 修改root密码为root并授权
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;