CREATE CATALOG

Syntax

CREATE CATALOG catalog_name

CREATE CATALOG can only be performed by a super user in the def catalog

Description

Creates a catalog and the mysql, sys and performance_schema schemas inside the catalog.

Note that no users are created.

Example

create catalog cat1;
use catalog cat1;
create user root@localhost;
grant all privileges on *.* to root@localhost;
create database test;

Limitations

The catalog name is limited to 64 characters. All characters must be in the basic ASCII set: (A-Z, a-z, -, _) This limitations is to be able to run catalogs with engines like InnoDB which has limited space in their internal data dictionary.

See also

• marriadb-install-db can be used to create multiple catalogs with a default root user in one go.
• DROP CATALOG