centos安装mysql8028
下载好了解压出来
mysql-community-client-8.0.28-1.el7.x86_64
mysql-community-client-plugins-8.0.28-1.el7.x86_64
mysql-community-common-8.0.28-1.el7.x86_64
mysql-community-devel-8.0.28-1.el7.x86_64
mysql-community-embedded-compat-8.0.28-1.el7.x86_64
mysql-community-icu-data-files-8.0.28-1.el7.x86_64
mysql-community-libs-8.0.28-1.el7.x86_64
mysql-community-libs-compat-8.0.28-1.el7.x86_64
mysql-community-server-8.0.28-1.el7.x86_64
mysql-community-test-8.0.28-1.el7.x86_64
我已经下载好了，这里放一个网盘下载链接：
https://url10.ctfile.com/d/25666910-50740516-e8e9ca?p=4232
（访问密码：4232）
然后再在别处创建个文件夹，里面装这几项
mysql-community-common-8.0.28-1.el7.x86_64.rpm
mysql-community-common-8.0.28-1.el7.x86_64.rpm
mysql-community-libs-8.0.28-1.el7.x86_64.rpm
mysql-community-client-8.0.28-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm
mysql-community-server-8.0.28-1.el7.x86_64.rpm
然后传输到Linux系统中/usr/local/mysqls去,没mysql文件夹就自己新建一个
然后检查mysql需要的依赖
rpm -qa|grep libaio
如果无输出，则说明没有，需要执行下载：
yum -y install libaio
再检查net-tools
rpm -qa|grep net-tools
如果无输出，则说明没有，需要执行下载：
yum -y install net-tools
传输成功后按照以下顺序执行，千万不能顺序出错，否则可能出错误
(最好是找一个txt文件把下面的代码复制进去，把我文件名替换成你的文件名，然后再复制到linux系统里一句一句的去执行)
rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm
若安装报错，可以在报错的rpm语句后面加上--nodeps --force，比如第二个安装报错了，
rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm
那就后面加上--nodeps --force重新执行
rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm --nodeps --force
对安装路径进行授权
chown mysql:mysql /var/lib/mysql -R
mkdir /var/log/mysql
chown mysql:mysql /var/log/mysql -R
初始化mysql
mysqld --initialize
授权
chmod -R 777 /var/lib/mysql/auto.cnf
chown mysql:mysql /var/lib/mysql -R
启动mysql服务
systemctl start mysqld.service
检查mysql状态
systemctl status mysqld.service
查看mysql初始密码
cat /var/log/mysqld.log | grep password
登录mysql
mysql -u root -p
修改mysql密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
致此，mysql安装完毕。
（安装过程中若出现报错，可以试着把授权代码都再次执行一遍）
若出现无法修改密码
查看当前设置
show variables like 'validate_password%';
修改密码长度
set global validate_password.length=6;
修改密码等级
set global validate_password.policy=LOW;
设置check_name
set global validate_password.check_user_name=OFF;
再次修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
设置远程访问
create user 'root'@'%' identified with mysql_native_password by '123456';
给root授予所有操作权限
grant all privileges on *.* to 'root'@'%' with grant option;
刷新权限
flush privileges;
在linux系统的防火墙里开放3306端口
sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙使得开放的端口生效
sudo firewall-cmd --reload
修改mysql端口
vi /etc/my.conf
在里面的[mysqld]下面添加端口，有port就修改port后面的端口，没有直接加上port=你要设置的端口号
[mysqld]
port=端口号
（mysql默认端口号是3306）
在linux系统的防火墙里开放端口
sudo firewall-cmd --zone=public --add-port=端口号/tcp --permanent
查询安装的mysql
yum list installed | grep mysql
卸载mysql
yum -y remove mysql-community-client.x86_64
yum -y remove mysql-community-client-plugins.x86_64
yum -y remove mysql-community-common.x86_64
yum -y remove mysql-community-icu-data-files.x86_64
yum -y remove mysql-community-libs.x86_64
yum -y remove mysql-community-server.x86_64
文章来源
https://blog.csdn.net/weixin_53132064/article/details/126188742
https://blog.csdn.net/weixin_53132064/article/details/126188742