Where does MySQL store information about various options you've set for a database?

MySQL

MySQL stores information about various options and configurations for a database in the MySQL system database, particularly within the variables and options tables. Additionally, server configuration options can be set in the MySQL configuration file (usually named my.cnf or my.ini), which is read during server startup. The current settings can also be queried using the SHOW VARIABLES command.