1SHOW VARIABLES LIKE 'skip_name_resolve';
2Variable_name	Value
3skip_name_resolve	ON
4SHOW GLOBAL VARIABLES LIKE 'skip_name_resolve';
5Variable_name	Value
6skip_name_resolve	ON
7SHOW SESSION VARIABLES LIKE 'skip_name_resolve';
8Variable_name	Value
9skip_name_resolve	ON
10SELECT @@skip_name_resolve;
11@@skip_name_resolve
121
13SELECT @@LOCAL.skip_name_resolve;
14ERROR HY000: Variable 'skip_name_resolve' is a GLOBAL variable
15SELECT @@GLOBAL.skip_name_resolve;
16@@GLOBAL.skip_name_resolve
171
18SET @@skip_name_resolve=0;
19ERROR HY000: Variable 'skip_name_resolve' is a read only variable
20SET @@LOCAL.skip_name_resolve=0;
21ERROR HY000: Variable 'skip_name_resolve' is a read only variable
22SET @@GLOBAL.skip_name_resolve=0;
23ERROR HY000: Variable 'skip_name_resolve' is a read only variable
24