Mysql部署

• 环境介绍
  
• 关闭防火墙及SELINUX

systemctl stop firewaald
systemctl disable firewalld
setenforce 0
sed -i  '/^SELINUX=/s/enforcing/disabled/' /etc/selinux/config

• 下载
  官方下载地址

• 解压

tar -xvf mysql-8.0.24-1.el8.x86_64.rpm-bundle.tar

• 安装

yum -y install mysql-community-*.rpm

耐心等待安装完成

• [mysqld]内增加配置：lower_case_table_names=1

vi /etc/my.cnf

[mysqld]
lower_case_table_names=1
server-id=1
log-bin=/var/log/mysql/mysql-bin.log

如图：

• 启动服务

systemctl start mysqld

• 获取初始密码

grep password /var/log/mysqld.log

• 登陆

mysql -u root -p'qyZc%ds%#0;;'

• 配置

alter user 'root'@'localhost' identified by '你的密码';
update mysql.user set host='%' where user='root';
flush privileges;
alter user root@'%' identified with mysql_native_password by '你的密码';
flush privileges;

• 测试远程连接