mysql語句-學習思路

標籤：

實驗

 

information_schemamysqlperformance_schemareplicate-ignore-db = mysqlbinlog-ignore-db = mysqlbinlog-ignore-db = information_schemabinlog-ignore-db = performance_schema

 

 

drop user ‘root‘@‘lanny‘;drop user ‘‘@‘lanny‘;grant all on *.* to [email protected]‘A‘ identified by ‘123‘; #會將A轉為a,因為不支援大寫drop user ‘lanny‘@‘a‘;#這種有可能刪不掉.delete from mysql.user where user=‘lanny‘ and host=‘a‘;

 

 

一鍵建立從庫方法1
首先通過批量分發資料方案,把主庫的全備發布到從庫同步的機器上,可以做多台.
然後再製作如下批量做從庫指令碼一鍵完成多台機器從庫的製作.

mysql語句-學習思路