As an innovation to introduce in MariaDB 10.3, I would like to suggest that MariaDB supports temporary (session) databases:

• In such databases, all created tables will be temporary, independently if we specify the TEMPORARY clause or not when creating tables on such database.

• It would be a "shortcut" in order to assure that ALL tables created at top a specific database remain always temporary.

• As temporary tables are always per user session and connection, that would avoid problems such as tables which have not been declared temporary could interfere between users.

NEW SYNTAX:

CREATE [OR REPLACE] [TEMPORARY] {DATABASE | SCHEMA} [IF NOT EXISTS] db_name

    [create_specification] ...

create_specification:

    [DEFAULT] CHARACTER SET [=] charset_name

  | [DEFAULT] COLLATE [=] collation_name