1.下载安装包
先打开https://dev.mysql.com/downloads/mysql/选择要下载的版本
2.检查环境有没有安装过mariadb
注意:centOs会默认安装,为了避免冲突,先行卸载
rpm -qa|grep mariadb
卸载命令:
rpm -e mariadb.XXX --nodeps
3.创建存放的文件夹,解压jar包
在/user/local下创建
mkdir mysql
将之前下载的jar包存放到该文件夹下面
tar -xvf mysql-8.0.27-1.el8.x86_64.rpm-bundle.tar
4.安装
都可以在解压的文件里面找到对应的,写法都是固定的
–nodeps 去掉依赖
–force 强制安装
rpm -ivh mysql-community-common-8.0.27-1.el8.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.27-1.el8.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.27-1.el8.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.27-1.el8.x86_64.rpm --nodeps --force
5.初始化和配置
mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld
6.查看修改密码
cat /var/log/mysqld.log | grep password
7.修改密码
alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘123456’;
8.开启远程访问授权
create user 'root'@'%' identified with mysql_native_password by '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
9. 重启mysql服务
退出
exit
重启服务
service mysqld restart
10. 开放防火墙端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --zone=public --remove-port=3306/tcp --permanent
firewall-cmd --reload