mysql> show global variables like "%read_only%";
mysql> flush tables with read lock;
mysql> set global read_only=1;
mysql> show global variables like "%read_only%";
mysql> grant replication slave on *.* to'repl'@'%' identified by'repl';
# 格式:mysql> GRANT REPLICATION SLAVE ON *.* TO'帐号'@'从服务器IP或主机名' IDENTIFIED BY'密码';