CentOS8安装mysql

---

准备

关闭防火墙
#禁用，禁止开机启动： systemctl disable firewalld
#停止运行： systemctl stop firewalld

清理旧版本

查看 mariadb 的安装包
rpm -qa | grep mariadb
卸载mariadb
rpm -e mariadb-XXX --nodeps
再次查看 mariadb 的安装包
rpm -qa | grep mariadb

安装

选择安装版本

MySQL官网网址：https://dev.mysql.com/downloads/mysql/

下载rpm包

rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

安装MySQL

yum -y install mysql-community-server

启动

启动MySQL服务
systemctl start mysqld
设置开机自启
systemctl enable mysqld

初始化配置

修改初始密码
查看MySQL默认密码
cat /var/log/mysqld.log | grep “A temporary password is generated for root”

2020-09-18T16:23:37.947517Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: OhGu7/sC-t%
登录数据库
mysql -uroot -p
输入刚查到的密码（如：OhGu7/sC-t%）
修改密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘MySQL@2020’;
退出
exit
修改编码
vim /etc/my.cnf
新增

character_set_server=utf8
init_connect=‘SET NAMES utf8’

重启mysql
systemctl restart mysqld
用新密码登录MySQL
systemctl restart mysqld
设置远程连接
create user ‘root’@’%’ identified with mysql_native_password by ‘MySQL@2020’;
grant all privileges on . to ‘MySQL@2020’@’%’ with grant option;
修改加密规则
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘MySQL@2020’ PASSWORD EXPIRE NEVER;
刷新修改后权限
flush privileges;
退出
exit

连接测试

可以通过远程客户端或者服务测试，
查询本机IP，默认端口3306