centos安装mysql8028

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