Linux安装mysql 开启bingo日志

Linux安装mysql 开启bingo日志

1. 下载MySQL源安装包。

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2. 安装MySQL源。

yum -y install mysql57-community-release-el7-11.noarch.rpm

3. 检查MySQL源是否安装成功。

yum repolist enabled | grep mysql.*

4. 安装成功会返回如下结果。MySQL源安装成功
5. 安装MySQL服务器。

yum install mysql-community-server

6. 修改mysql配置文件/etc/my.inf

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=mysql-bin #添加这一行就ok
binlog-format=ROW #选择row模式
server_id=1 #配置mysql replaction需要定义，不能和canal的slaveId重复
character-set-server=utf8

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

7. 启动MySQL服务并查看MySQL服务的状态。

    systemctl start mysqld.service
    systemctl status mysqld.service

8. 通过查询mysql日志找到初始密码

grep password /var/log/mysqld.log

9. mysql -u root -p enter回车填写密码进入mysql命令行

10. 解决报错：You must reset your password using ALTER USER statement before executing this statement.

ALTER USER USER() IDENTIFIED BY 'Mmc..5211314';

11. 查看开启日志是否生效

show variables like '%log_bin%';

12. 开启master的binary log记录功能，并且选择模式为ROW

log-bin=mysql-bin #添加这一行就ok
binlog-format=ROW #选择row模式
server_id=1 #配置mysql replaction需要定义，不能和canal的slaveId重复