Debian Codegraph @

mysql-test/suite/sys_vars/r/admin_address_basic.result

raw
1 select @@global.admin_address;
2 @@global.admin_address
3 NULL
4 select @@session.admin_address;
5 ERROR HY000: Variable 'admin_address' is a GLOBAL variable
6 show global variables like 'admin_address';
7 Variable_name Value
8 admin_address
9 show session variables like 'admin_address';
10 Variable_name Value
11 admin_address
12 select * from performance_schema.global_variables where variable_name='admin_address';
13 VARIABLE_NAME VARIABLE_VALUE
14 admin_address
15 select * from performance_schema.session_variables where variable_name='admin_address';
16 VARIABLE_NAME VARIABLE_VALUE
17 admin_address
18 select * from performance_schema.variables_info where variable_name='admin_address';
19 VARIABLE_NAME VARIABLE_SOURCE VARIABLE_PATH MIN_VALUE MAX_VALUE SET_TIME SET_USER SET_HOST
20 admin_address COMPILED 0 0 NULL NULL NULL
21 set global admin_address='::1';
22 ERROR HY000: Variable 'admin_address' is a read only variable
23 set session admin_port='::1';
24 ERROR HY000: Variable 'admin_port' is a read only variable
25 set persist admin_port='::1';
26 ERROR HY000: Variable 'admin_port' is a read only variable
27 # restart: --skip-name-resolve --admin-address=127.0.0.1 --admin_port=ADMIN_PORT
28 select * from performance_schema.global_variables where variable_name='admin_address';
29 VARIABLE_NAME VARIABLE_VALUE
30 admin_address 127.0.0.1
31 select * from performance_schema.session_variables where variable_name='admin_address';
32 VARIABLE_NAME VARIABLE_VALUE
33 admin_address 127.0.0.1
34 #
35 # Starting mysqld in the regular mode...
36 #
37 # restart