Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33694

create and drop catalogs inside MariaDB Server

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • catalogs
    • None

    Description

      At the moment a MariaDB Def superuser can create a catalog with the "CREATE CATALOG" command, but this does not create the privilege tables. You can also use mariadb-install-db, but this requires at least OS access to the MariaDB datadir and Def superuser privileges.

      It is not possible for many admin panel UIs to gain enough OS privileges to run mariadb-install-db for security reasons. So, there should be a way to create a new catalog inside MariaDB that just uses the Def superuser.

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-31711 DROP CATALOG should drop all included tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-33695 Catalogs: DROP CATALOG should have a FORCE option

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-31542 Add multi-tenancy catalogs to MariaDB

          • Major - Major loss of function.
          • Stalled

          Activity

            People

              monty Michael Widenius
              TheLinuxJedi Andrew Hutchings
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.