2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_host';
8
VARIABLE_NAME VARIABLE_VALUE
10
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_port';
11
VARIABLE_NAME VARIABLE_VALUE
13
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_user';
14
VARIABLE_NAME VARIABLE_VALUE
16
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_password';
17
VARIABLE_NAME VARIABLE_VALUE
18
REPORT_PASSWORD my_password
19
show global variables like 'report_host';
20
Variable_name report_host
22
show global variables like 'report_port';
23
Variable_name report_port
25
show global variables like 'report_user';
26
Variable_name report_user
28
show global variables like 'report_password';
29
Variable_name report_password
31
set @@global.report_host='my.new.address.net';
32
ERROR HY000: Variable 'report_host' is a read only variable