Status: Open (View Workflow)
Fix Version/s: None
MySQL/MariaDB uses the file DATADIR/dbname/db.opt to store
the database default character set and collation.
We could also store more per-database options in this file.
For example, a default storage engine would be convenient:
Almost all system variables that can have both global and session
scope could be set per-database.
Some useful examples:
Some global-only variables could also possibly be set per-database: