Centos8_2004安装配置mysql8.0.21

1、安装Yum Repository

[root@localhost ~]# wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

2、使用rpm来安装MySQL

[root@localhost ~]# rpm -ivh mysql80-community-release-el8-1.noarch.rpm

3、使用yum安装mysql服务

[root@localhost ~]# yum install mysql-server

4、检查是否已经设置为开机启动MySQL服务

[root@localhost ~]# systemctl list-unit-files|grep mysqld
mysqld.service disabled
mysqld@.service disabled

[root@localhost ~]# systemctl enable mysqld.service   #设置开机启动
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.
[root@localhost ~]# systemctl list-unit-files|grep mysqld
mysqld.service enabled
mysqld@.service disabled
 
[root@localhost ~]# ps -ef|grep mysql # 查看是否启动MySQL服务
root 4311 32702 0 21:07 pts/4 00:00:00 grep --color=auto mysql
[root@localhost ~]# systemctl start mysqld.service #启动服务

5、进入查看

6、进入 mysql 更改默认密码

alter user root@localhost identified by ‘1234‘;
flush privileges; # 刷新MySQL的系统权限
quit;

7、建立远程连接

# 开放3306端口
[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
?
# 重启防火墙
[root@localhost ~]# firewall-cmd --reload
?
# 查看防火墙状态，3306端口已开
[root@localhost ~]# firewall-cmd --list-all

8、进入 mysql 建立远程连接

# 允许建立远程连接
create user ‘root‘@‘%‘ identified with mysql_native_password by ‘密码‘;
grant all privileges on *.* to ‘root‘@‘%‘ with grant option;
flush privileges;

Centos8_2004安装配置mysql8.0.21