mysql语句-学习思路

-ignore-db = mysql binlog-ignore-db = mysql binlog-ignore-db = information_schema binlog-ignore-db = performance_schema

 

 

drop user ‘root‘@‘lanny‘;
drop user ‘‘@‘lanny‘;

grant all on *.* to lanny@‘A‘ identified by ‘123‘; #会将A转为a,因为不支持大写
drop user ‘lanny‘@‘a‘;#这种有可能删不掉.
delete from mysql.user where user=‘lanny‘ and host=‘a‘;

 

 

一键创建从库方法1
首先通过批量分发数据方案,把主库的全备发布到从库同步的机器上,可以做多台.
然后再制作如下批量做从库脚本一键完成多台机器从库的制作.

mysql语句-学习思路

标签：