1select @@global.character_sets_dir; 2@@global.character_sets_dir 3MYSQL_CHARSETSDIR/ 4select @@session.character_sets_dir; 5ERROR HY000: Variable 'character_sets_dir' is a GLOBAL variable 6show global variables like 'character_sets_dir'; 7Variable_name Value 8character_sets_dir MYSQL_CHARSETSDIR/ 9show session variables like 'character_sets_dir'; 10Variable_name Value 11character_sets_dir MYSQL_CHARSETSDIR/ 12select * from information_schema.global_variables where variable_name='character_sets_dir'; 13VARIABLE_NAME VARIABLE_VALUE 14CHARACTER_SETS_DIR MYSQL_CHARSETSDIR/ 15select * from information_schema.session_variables where variable_name='character_sets_dir'; 16VARIABLE_NAME VARIABLE_VALUE 17CHARACTER_SETS_DIR MYSQL_CHARSETSDIR/ 18set global character_sets_dir="foo"; 19ERROR HY000: Variable 'character_sets_dir' is a read only variable 20set session character_sets_dir="foo"; 21ERROR HY000: Variable 'character_sets_dir' is a read only variable 22