centeros安装mySQL，开启binlog日志

一、安装

 # 查看yum是否安装过mysql
yum list installed mysql*
// 如果有 则依次删除 清理干净
yum remove mysql-community-client
rpm -qa | grep -i mysql 
rpm -e mysql57-community-release-el7-9.noarch
whereis mysql
rm -rf /usr/bin/mysql

// 获取
wget http://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
sudo rpm -Uvh mysql80-community-release-el7-1.noarch.rpm

// 安装
yum install mysql-community-server

// 启动
systemctl start mysqld.service

systemctl status mysqld.service

// 获取安装的默认密码
grep 'temporary password' /var/log/mysqld.log

// 连接MySQL
mysql -uroot -p

// 修改默认密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '1@3$qWeR';

// 切换数据库
use mysql
// 允许远程连接
update user set host='%' where user='root';
// 查看 user
select host,user,plugin from user;

// 修改密码强度策略
// 查看
SHOW VARIABLES like 'validate_password%';
// 修改
set global validate_password.policy=0;
set global validate_password.length=4;
set global validate_password.check_user_name=0;

// 将密码修改为简单密码
ALTER USER 'root'@'%' IDENTIFIED BY 'root';


# Navicat 15 
# select host,user,plugin from user;
# update user set plugin='mysql_native_password' where user='root';
#ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';

// 查看防护墙状态
systemctl status firewalld
// 开启防火墙
systemctl start firewalld
开启防火墙 3306 端口 允许访问 MySQL
firewall-cmd --zone=public --add-port=3306/tcp --permanent 
// 重新加载防火墙配置
firewall-cmd --reload


// --permanent 永久生效,没有此参数重启后失效
firewall-cmd --zone=public --add-port=80/tcp --permanent

firewall-cmd --zone=public --query-port=80/tcp

firewall-cmd --zone=public --remove-port=80/tcp --permanent

二、开启binlog日志
在/etc路径下找到文件my.conf，写入如下内容

log-bin=mysql-bin
server-id=1
binlog_format = ROW

然后重启mysql
在客户度查询语句show binary logs，出现如下证明成功了

三、重启mysql命令

systemctl restart mysqld.service

参考：
https://blog.csdn.net/qq_36582604/article/details/80526287

https://www.cnblogs.com/lifan1998/p/9177731.html