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