本教程是通过deb安装包进行安装
Mysql版本为5.7.33
1、下载deb安装包
到官网找到想要安装的Mysql版本:
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]下
重启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删掉
5、开启远程连接
将配置文件中的bind-address=127.0.0.1改为0.0.0.0
将root用户的host改为%
update user set host='%' where user='root';
重启mysql服务然后 开启服务器防火墙3306端口即可进行连接