# # only global # select @@global.report_password; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.report_password; show global variables like 'report_password'; show session variables like 'report_password'; --disable_warnings select * from performance_schema.global_variables where variable_name='report_password'; select * from performance_schema.session_variables where variable_name='report_password'; --enable_warnings # # show that it's read-only # --error ER_INCORRECT_GLOBAL_LOCAL_VAR set global report_password=1; --error ER_INCORRECT_GLOBAL_LOCAL_VAR set session report_password=1;