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] 6select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_host'; 7VARIABLE_NAME VARIABLE_VALUE 8REPORT_HOST 127.0.0.1 9select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_port'; 10VARIABLE_NAME VARIABLE_VALUE 11REPORT_PORT 9308 12select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_user'; 13VARIABLE_NAME VARIABLE_VALUE 14REPORT_USER my_user 15select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_password'; 16VARIABLE_NAME VARIABLE_VALUE 17REPORT_PASSWORD my_password 18show global variables like 'report_host'; 19Variable_name report_host 20Value 127.0.0.1 21show global variables like 'report_port'; 22Variable_name report_port 23Value 9308 24show global variables like 'report_user'; 25Variable_name report_user 26Value my_user 27show global variables like 'report_password'; 28Variable_name report_password 29Value my_password 30set @@global.report_host='my.new.address.net'; 31ERROR HY000: Variable 'report_host' is a read only variable 32end of tests 33include/rpl_end.inc 34