1select @@global.log_builtin_as_identified_by_password;
2@@global.log_builtin_as_identified_by_password
30
4select @@session.log_builtin_as_identified_by_password;
5ERROR HY000: Variable 'log_builtin_as_identified_by_password' is a GLOBAL variable
6show global variables like 'log_builtin_as_identified_by_password';
7Variable_name	Value
8log_builtin_as_identified_by_password	OFF
9show session variables like 'log_builtin_as_identified_by_password';
10Variable_name	Value
11log_builtin_as_identified_by_password	OFF
12select * from information_schema.global_variables where variable_name='log_builtin_as_identified_by_password';
13VARIABLE_NAME	VARIABLE_VALUE
14LOG_BUILTIN_AS_IDENTIFIED_BY_PASSWORD	OFF
15select * from information_schema.session_variables where variable_name='log_builtin_as_identified_by_password';
16VARIABLE_NAME	VARIABLE_VALUE
17LOG_BUILTIN_AS_IDENTIFIED_BY_PASSWORD	OFF
18set global log_builtin_as_identified_by_password=1;
19select @@global.log_builtin_as_identified_by_password;
20@@global.log_builtin_as_identified_by_password
211
22set session log_builtin_as_identified_by_password=1;
23ERROR HY000: Variable 'log_builtin_as_identified_by_password' is a GLOBAL variable and should be set with SET GLOBAL
24set global log_builtin_as_identified_by_password=default;
25