centos 下载mysql rpm_mysql8 rpm安装 centos

cd ~/src

tar -xvf mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar

3、开始安装

卸载 系统自带的mariadb

rpm -qa|grep mariadb

rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps

用rpm安装 common libs client server

rpm -ivU mysql-community-common-8.0.22-1.el7.x86_64.rpm --nodeps --force

rpm -ivU mysql-community-libs-8.0.22-1.el7.x86_64.rpm --nodeps --force

rpm -ivU mysql-community-client-8.0.22-1.el7.x86_64.rpm --nodeps --force

rpm -ivU mysql-community-server-8.0.22-1.el7.x86_64.rpm --nodeps --force

rpm -ap |grep mysql

初始化数据库

mysqld --initialize

chown mysql:mysql /var/lib/mysql -R

systemctl start mysqld.service

systemctl enable mysqld

登录修改密码

查看initialize生成的默认密码

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

登录修改root用户密码,并进行远程访问授权

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'baohedata@20200919';

flush privileges;

再次用新密码登录

添加授权远程登录账户

create user 'root'@'%' identified with mysql_native_password by 'root';

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;

关闭防火墙

systemctl stop firewalld.service

systemctl disable firewalld

navicate远程登录

安装完毕！