|
1
by brian
clean slate |
1 |
# Verify that mysqld init time --report-{host,port,user,password} parameters
|
2 |
# are SHOW-able and SELECT-able FROM INFORMATION_SCHEMA.global_variables
|
|
3 |
||
4 |
source include/master-slave.inc; |
|
5 |
||
6 |
connection slave; |
|
7 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_host'; |
|
8 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_port'; |
|
9 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_user'; |
|
10 |
select * from Information_schema.GLOBAL_VARIABLES where variable_name like 'report_password'; |
|
11 |
query_vertical show global variables like 'report_host'; |
|
12 |
query_vertical show global variables like 'report_port'; |
|
13 |
query_vertical show global variables like 'report_user'; |
|
14 |
query_vertical show global variables like 'report_password'; |
|
15 |
||
16 |
# to demonstrate that report global variables are read-only
|
|
17 |
error ER_INCORRECT_GLOBAL_LOCAL_VAR; |
|
18 |
set @@global.report_host='my.new.address.net'; |
|
19 |
||
20 |
||
21 |
--echo end of tests |