1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6set global max_connections=151; 7include/stop_slave.inc 8include/start_slave.inc 9include/sync_slave_sql_with_master.inc 10show variables like 'init_slave'; 11Variable_name Value 12init_slave set global max_connections=500 13show variables like 'max_connections'; 14Variable_name Value 15max_connections 500 16reset master; 17show variables like 'init_slave'; 18Variable_name Value 19init_slave 20show variables like 'max_connections'; 21Variable_name Value 22max_connections 151 23include/sync_slave_sql_with_master.inc 24set @my_global_init_connect= @@global.init_connect; 25set global init_connect="set @c=1"; 26show variables like 'init_connect'; 27Variable_name Value 28init_connect set @c=1 29include/sync_slave_sql_with_master.inc 30set global init_connect= @my_global_init_connect; 31set global max_connections= default; 32include/rpl_end.inc 33