mysql

linux开启binlog

#必须在[mysqld]下面

[mysqld]
log-bin=mysql-bin
server_id = 195

重启mysql服务

#5.7以下

service mysql restart

 

#5.7以上

service mysqld restart

 

SQL查看是否开启成功

show global variables like 'log_bin';

 

设置

set global server_id=195;

set global binlog_format=ROW

 

 

创建用户

CREATE USER 'dev'@'%' IDENTIFIED BY 'dev';

授权dev查询music数据库的所有表权限

grant select on music.* to 'dev'@'%';

管理员

grant all privileges on music.* to 'dev'@'%';

 flush privileges

 

GRANT CREATE,GRANT OPTION,ALTER,DELETE,INDEX,INSERT,SELECT,UPDATE,CREATE VIEW,SHOW VIEW,ALTER ROUTINE,CREATE ROUTINE,EXECUTE ON *.* TO 'dev'@'%';