Anyone know how I can check my MySQL system variables? I have shell access (SSH) and want to determine what the MySQL server's current character set and collation are.
Apparently these are stored in the following system variables:
so is there some way I can display these from the command line?
Any help gratefully received,