centos7安装mysql8.0

一、基础安装

1. 删除centos默认mariaDB

[root@VM-4-17-centos ~]# rpm -qa | grep -i mariadb
mariadb-libs-5.5.68-1.el7.x86_64
[root@VM-4-17-centos ~]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

2. 判断是否删除干净

[root@VM-4-17-centos ~]# rpm -qa | grep mysql

3. rpm安装mysql

[root@VM-4-17-centos ~]# wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm
[root@VM-4-17-centos ~]# yum -y install mysql80-community-release-el7-7.noarch.rpm
[root@VM-4-17-centos ~]# yum install mysql-community-server --nogpgcheck

4. 启动mysql

[root@VM-4-17-centos ~]# systemctl enable --now mysqld

5. 获取初始密码

[root@VM-4-17-centos ~]# grep 'temporary password' /var/log/mysqld.log

6. 使用初始密码进入数据库

[root@VM-4-17-centos ~]# mysql -uroot -p

7. 修改初始密码

[root@VM-4-17-centos ~]# ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxx';
[root@VM-4-17-centos ~]# flush privileges;

二、拓展部分

修改启动端口

1. 找到 mysql 配置文件

sudo find / -name my.cnf

2. 编辑找到的 mysql 配置文件，编辑或添加port字段

[mysqld]
port = XXXX

3. 重启MySQL服务

sudo systemctl restart mysqld

4. 查看端口状态

netstat -anp | grep XXXX