官网下载

镜像选择

进入下载，选择版本，找到类型mysql-8.0.28-1.el8.x86_64.rpm-bundle.tar的包复制链接

在CentOS中使用wget进行下载

删除已有数据库

查看已有数据库
rpm -qa | grep mysql
rpm -qa | grep mariadb
移除已有数据库
rpm -e --nodeps mariadb-xxx

安装

创建mysql文件夹，并将tar包放入其中进行解压

tar -xvf mysql-8.0.25-1.el8.x86_64.rpm-bundle.tar

顺序安装以下rpm包

rpm -ivh mysql-community-common-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-server-8.0.28-1.el8.x86_64.rpm --force --nodeps  # 注意末尾强制安装指令，否则会报错

启动

systemctl start mysqld
查看
netstat -ntulp | grep 3306
开机启动
systemctl enable mysqld

访问

获取密码

cat /var/log/mysqld.log | grep password

修改密码

MySQL有密码强校验机制，简单密码无法设置，可以先关闭

vim /etc/my.cnf
# 新增
validate_password.check_user_name=OFF
validate_password.length=4
validate_password.mixed_case_count=0
validate_password.number_count=0
validate_password.policy=0
validate_password.special_char_count=0

重启服务systemctl restart mysqld

进入MySQL修改密码

mysql -uroot -p

alter user 'root'@'localhost' identified by '123456';

远程访问

注意：root用户无法通过远程进行访问的，如果需要远程访问，需要添加一个普通用户并授权访问

# 创建一个用户指定密码格式和密码
CREATE USER `authUser`@`%` IDENTIFIED WITH mysql_native_password BY '123456';
# 授权
GRANT ALL ON *.* TO `authUser`@`%` WITH GRANT OPTION;
# 刷新
FLUSH PRIVILEGES;

如果远程无法访问，注意需要开启防火墙

# 查看已开放端口
firewall-cmd --list-all
# 开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
# 重启生效
firewall-cmd --reload

Ubuntu安装

sudo apt-get update
sudo apt-get install mysql-server
# 启动
sudo /etc/init.d/mysql start
# 状态
sudo /etc/init.d/mysql status
# 停止
sudo /etc/init.d/mysql stop
# 重启
sudo /etc/init.d/mysql restart

# 进入MySQL
sudo mysql
# 创建用户
create user test@'%' identified by 'test';
## 授权
grant all privileges on *.* to test@'%';
## 刷新权限
flush privileges;

修改远程访问

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# 调整bind-address 0.0.0.0 然后重启

ubuntu离线安装

ubuntu2404
mysql8.4.4

tar -xvf mysql-server_8.4.4-1ubuntu24.04_amd64.deb-bundle.tar

dpkg -i mysql-community-client-plugins_8.4.4-1ubuntu24.04_amd64.deb
dpkg -i mysql-community-client-core_8.4.4-1ubuntu24.04_amd64.deb
dpkg -i mysql-common_8.4.4-1ubuntu24.04_amd64.deb
dpkg -i mysql-community-client_8.4.4-1ubuntu24.04_amd64.deb
dpkg -i libmysqlclient24_8.4.4-1ubuntu24.04_amd64.deb
dpkg -i libmysqlclient-dev_8.4.4-1ubuntu24.04_amd64.deb
dpkg -i mysql-client_8.4.4-1ubuntu24.04_amd64.deb
dpkg -i mysql-community-server-core_8.4.4-1ubuntu24.04_amd64.deb # 依赖报错 apt install libmecab2 若没有需要更新 apt update
dpkg -i mysql-community-server_8.4.4-1ubuntu24.04_amd64.deb # 这里会输入密码
dpkg -i mysql-server_8.4.4-1ubuntu24.04_amd64.deb

service mysql restart

安装防火墙

apt install firewalld

注意远程不能使用root访问

# 进入MySQL
mysql -u root -p
# 创建用户
create user user@'%' identified by 'user';
## 授权
grant all privileges on *.* to user@'%';
## 刷新权限
flush privileges;