Ubuntu2204安装MySQL5_7

Ubuntu直接使用下面的命令默认安装的是MySQL8.0，但是有时候为了兼容我们需要使用MySQL5.7。

# 会默认安装MySQL 8.0
sudo apt install mysql-sever mysql-client

解决方案如下：

wget https://repo.mysql.com//mysql-apt-config_0.8.12-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb

这里选择MySQL5.7即可

然后更新

sudo apt update

报错解决

The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29

解决

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29

安装MySQL5.7

sudo apt install mysql-client=5.7.38-1ubuntu18.04 -y
sudo apt install mysql-community-server=5.7.38-1ubuntu18.04 -y

管理

service mysql status
# restrat
sudo service mysql restart
# stop
sudo service mysql stop

创建用户与数据库

CREATE USER 'terwer'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'terwer'@'%' WITH GRANT OPTION;
flush privileges;

create database databasename default character set utf8mb4 collate utf8mb4_general_ci;