mysql -e 'SHOW VARIABLES LIKE "character_set_server";'
Show a server configuration variable
Queries the variables table for one setting; change the LIKE pattern to match many, such as max_connections or time_zone. Related: SHOW STATUS for runtime counters.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.