1SELECT @@GLOBAL.default_authentication_plugin; 2@@GLOBAL.default_authentication_plugin 3mysql_native_password 4SELECT COUNT(@@GLOBAL.default_authentication_plugin); 5COUNT(@@GLOBAL.default_authentication_plugin) 61 71 Expected 8SET @@GLOBAL.default_authentication_plugin=1; 9ERROR HY000: Variable 'default_authentication_plugin' is a read only variable 10Expected error 'Read only variable' 11SELECT COUNT(@@GLOBAL.default_authentication_plugin); 12COUNT(@@GLOBAL.default_authentication_plugin) 131 141 Expected 15SELECT @@GLOBAL.default_authentication_plugin = VARIABLE_VALUE 16FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 17WHERE VARIABLE_NAME='default_authentication_plugin'; 18@@GLOBAL.default_authentication_plugin = VARIABLE_VALUE 191 201 Expected 21SELECT COUNT(@@GLOBAL.default_authentication_plugin); 22COUNT(@@GLOBAL.default_authentication_plugin) 231 241 Expected 25SELECT COUNT(VARIABLE_VALUE) 26FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 27WHERE VARIABLE_NAME='default_authentication_plugin'; 28COUNT(VARIABLE_VALUE) 291 301 Expected 31SELECT @@default_authentication_plugin = @@GLOBAL.default_authentication_plugin; 32@@default_authentication_plugin = @@GLOBAL.default_authentication_plugin 331 341 Expected 35SELECT COUNT(@@default_authentication_plugin); 36COUNT(@@default_authentication_plugin) 371 381 Expected 39SELECT COUNT(@@local.default_authentication_plugin); 40ERROR HY000: Variable 'default_authentication_plugin' is a GLOBAL variable 41Expected error 'Variable is a GLOBAL variable' 42SELECT COUNT(@@SESSION.default_authentication_plugin); 43ERROR HY000: Variable 'default_authentication_plugin' is a GLOBAL variable 44Expected error 'Variable is a GLOBAL variable' 45SELECT COUNT(@@GLOBAL.default_authentication_plugin); 46COUNT(@@GLOBAL.default_authentication_plugin) 471 481 Expected 49SELECT default_authentication_plugin = @@SESSION.default_authentication_plugin; 50ERROR 42S22: Unknown column 'default_authentication_plugin' in 'field list' 51Expected error 'Readonly variable' 52