Ubuntu20.04安装Mysql5.7

253 阅读1分钟

本教程是通过deb安装包进行安装
Mysql版本为5.7.33

1、下载deb安装包

官网找到想要安装的Mysql版本:

image.png

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_5.7.33-1ubuntu18.04_amd64.deb-bundle.tar

2、利用deb包进行安装

将下载到的压缩文件移动到新文件夹中方便后续安装

mkdir mysql5.7.33
mv mysql-server_5.7.33-1ubuntu18.04_amd64.deb-bundle.tar mysql5.7.33/

解压tar文件

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

解压后可以看到这些文件

libmysqlclient20_5.7.33-1ubuntu18.04_amd64.deb
mysql-client_5.7.33-1ubuntu18.04_amd64.deb
mysql-community-source_5.7.33-1ubuntu18.04_amd64.deb
mysql-server_5.7.33-1ubuntu18.04_amd64.deb
mysql-common_5.7.33-1ubuntu18.04_amd64.deb
mysql-testsuite_5.7.33-1ubuntu18.04_amd64.deb
libmysqlclient-dev_5.7.33-1ubuntu18.04_amd64.deb
mysql-community-client_5.7.33-1ubuntu18.04_amd64.deb
mysql-community-server_5.7.33-1ubuntu18.04_amd64.deb
libmysqld-dev_5.7.33-1ubuntu18.04_amd64.deb
mysql-community-test_5.7.33-1ubuntu18.04_amd64.deb

删除2个测试相关的包

sudo rm -f mysql-testsuite_5.7.33-1ubuntu18.04_amd64.deb
sudo rm -f mysql-community-test_5.7.33-1ubuntu18.04_amd64.deb

3、利用dpkg进行安装

sudo dpkg -i mysql-*.deb

安装过程中如果有报错, 去安装报错中需要的包就可以解决

4、安装完成后设置root用户密码

利用vim打开mysql默认配置文件

vim /etc/mysql/mysql.conf.d/mysqld.cnf

将skip-grant-tables添加到[mysqld]下

image.png 重启mysql服务

sudo service mysql restart

然后在终端中直接进入mysql

mysql -uroot

切换数据库到mysql数据库

use mysql;

将root用户的密码修改为你的密码

UPDATE mysql.user SET authentication_string=password('你的密码') WHERE User='root' AND Host ='localhost';

刷新

flush privileges;

然后将刚开始输入的skip-grant-tables删掉

image.png

5、开启远程连接

将配置文件中的bind-address=127.0.0.1改为0.0.0.0

image.png 将root用户的host改为%

update user set host='%' where user='root';

重启mysql服务然后 开启服务器防火墙3306端口即可进行连接