在CentOS 7安装MySQL 8.0

1. 使用root账户

---

2. 在MySQL官网中下载YUM源rpm安装包

https://dev.mysql.com/downloads/repo/yum/
Red Hat Enterprise Linux 7 / Oracle Linux 7 (Architecture Independent), RPM Package
mysql80-community-release-el7-2.noarch.rpm

---

3. 安装MySQL源

yum localinstall mysql80-community-release-el7-2.noarch.rpm

---

4. 安装MySQL

yum install mysql-community-server

---

5. 启动MySQL服务

systemctl start mysqld

---

6. 查看MySQL的启动状态

systemctl status mysqld

---

7. 设置MySQL开机启动

systemctl enable mysqld
systemctl daemon-reload

---

8. 修改MySQL root账户默认密码

使用grep 'temporary password' /var/log/mysqld.log找到默认密码

mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

---

9. 其他事项

如需重启MySQL服务，使用
systemctl restart mysqld
如需添加拥有所有权限的远程用户，使用
GRANT ALL PRIVILEGES ON *.* TO 'kyle'@'%' IDENTIFIED BY 'MyPassword4!' WITH GRANT OPTION;
如需配置默认编码为utf8，修改/etc/my.cnf配置文件，在[mysqld]下添加如下编码配置，
character_set_server=utf8
init_connect='SET NAMES utf8'
随后重启MySQL服务

默认配置文件路径：
配置文件：/etc/my.cnf 
日志文件：/var/log//var/log/mysqld.log 
服务启动脚本：/usr/lib/systemd/system/mysqld.service 
socket文件：/var/run/mysqld/mysqld.pid