ubuntu22.04下，MySQL5.7的安装备份

1 Ubuntu22.04安装MySQL5.7

1.1 MySQL下载安装

MySQL下载地址：https://downloads.mysql.com/archives/community/

 wget https://cdn.mysql.com/archives/mysql-5.7/mysql-server_5.7.29-1ubuntu18.04_amd64.deb-bundle.tar
 
 tar -xvf ./mysql-server_5.7.29-1ubuntu18.04_amd64.deb-bundle.tar

解压之后的软件包如下：

# 安装
sudo dpkg -i ./mysql-common_5.7.29-1ubuntu18.04_amd64.deb

sudo dpkg -i ./libmysqlclient20_5.7.29-1ubuntu18.04_amd64.deb 
 sudo dpkg -i ./libmysqlclient-dev_5.7.29-1ubuntu18.04_amd64.deb
sudo dpkg -i ./libmysqld-dev_5.7.29-1ubuntu18.04_amd64.deb 

sudo dpkg -i ./mysql-community-client_5.7.29-1ubuntu18.04_amd64.deb 

如果只使用上述的包，安装时会报错：

意思是：libtinfo5 没有被安装，需要手动下载，地址：https://ubuntu.pkgs.org/

# 下载上述包并安装
wget http://archive.ubuntu.com/ubuntu/pool/universe/n/ncurses/libtinfo5_6.3-2_amd64.deb
sudo dpkg -i ./libtinfo5_6.3-2_amd64.deb 

# 继续安装MySQL包
sudo dpkg -i ./mysql-community-client_5.7.29-1ubuntu18.04_amd64.deb
sudo dpkg -i ./mysql-client_5.7.29-1ubuntu18.04_amd64.deb
sudo dpkg -i ./mysql-community-source_5.7.29-1ubuntu18.04_amd64.deb
 
sudo dpkg -i ./mysql-community-server_5.7.29-1ubuntu18.04_amd64.deb

此时继续报错：libmecab2 没有被安装

# 继续在上面的地址处找安装包。下载：
wget http://archive.ubuntu.com/ubuntu/pool/main/m/mecab/libmecab2_0.996-14build9_amd64.deb
sudo dpkg -i ./libmecab2_0.996-14build9_amd64.deb

# 重新执行安装
sudo dpkg -i ./mysql-community-server_5.7.29-1ubuntu18.04_amd64.deb
# 执行操作时会要求输入密码，此处的密码即为后续root用户密码
sudo dpkg -i ./mysql-server_5.7.29-1ubuntu18.04_amd64.deb
sudo dpkg -i ./mysql-community-source_5.7.29-1ubuntu18.04_amd64.deb 

 # 检查MySQL状态
 systemctl status mysql

1.2 登陆后修改，使其他地址也可以登陆

mysql -uroot -pSmile-123

use mysql;
update user set