1. master mysql 中修改/etc/my.cnf 在mysqld下添加如下两行: log-bin=/var/lib/mysql/mysql-bin.log server-id=1 #binlog-do-db=DB1 #binlog-do-db=DB2 #如果备份多个数据库,重复设置这个选项即可 2.重启mysql,添加slave replication 用户 GRANT RE
为什么80%的码农都做不了架构师?>>> show grants for 'root'@'localhost'; show privileges ; mysql更改用户权限 This entry was posted by admin Monday, 26 April, 2010 1.“grant all on *.* toroot@’%’identified by ‘your