Linux安装mysql 开启bingo日志
- 下载MySQL源安装包。
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
- 安装MySQL源。
yum -y install mysql57-community-release-el7-11.noarch.rpm
- 检查MySQL源是否安装成功。
yum repolist enabled | grep mysql.*
- 安装成功会返回如下结果。MySQL源安装成功
- 安装MySQL服务器。
yum install mysql-community-server
- 修改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
- 启动MySQL服务并查看MySQL服务的状态。
systemctl start mysqld.service
systemctl status mysqld.service
- 通过查询mysql日志找到初始密码
grep password /var/log/mysqld.log
-
mysql -u root -p enter回车填写密码进入mysql命令行
-
解决报错:You must reset your password using ALTER USER statement before executing this statement.
ALTER USER USER() IDENTIFIED BY 'Mmc..5211314';
- 查看开启日志是否生效
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重复