MySQL Statement-Learning Ideas

Experiment

information_schemamysqlperformance_schemareplicate-ignore-db = mysqlbinlog-ignore-db =  Mysqlbinlog-ignore-db = information_schemabinlog-ignore-db = Performance_schema

Drop user'Root'@'Lanny';d ROP User"'@'Lanny'; Grant all on*. * to [email protected]'A'Identified by'123'; #会将A转为a because the uppercase drop user is not supported'Lanny'@'a'; #这种有可能删不掉. Delete from Mysql.user where user='Lanny'and host='a';

One-click Create from library Method 1
First, through the bulk distribution of data schemes, the master library is released to the machine synchronized from the library, you can do multiple stations.
Then make the following batch to do from the library script one click to complete the production of multiple machines from the library.

MySQL Statement-Learning Ideas