I've got a PostgreSQL database whose tables are divided among numerous schemas. Each schema includes a different group of access controls for instance, one schema may be read-simply to regular customers, while they're permitted to produce tables on another. Schemas also behave as namespaces, so customers don't need to bother about copying existing tables once they create brand new ones.
I wish to produce a similar setup using MySQL. Is there a similar concept? Otherwise, how do i most carefully simulate it? I'd prefer to not use multiple databases.
Database ought to be the nearest one.
Prefixing table names is what's completed with most MySQL-driven applications.