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

Use GRANT ... TO PUBLIC for default test database privileges

    XMLWordPrintable

    Details

      Description

      Currently, mysql_install_db provides default access to the test database by inserting some rows into the mysql.db table for the ''@'%' user account, but it does not insert any rows into the mysql.user table for that user account.

      These rows are currently inserted by the scripts/mysql_test_db.sql script:

      https://github.com/MariaDB/server/blob/mariadb-10.4.8/scripts/mysql_test_db.sql#L18

      This method has some negative consequences. See MDEV-13486 for more information.

      If we implement GRANT ... TO PUBLIC, then we should change mysql_install_db, so that mysql_install_db uses that instead.

      i.e.:

      GRANT ALL PRIVILEGES ON `test`.\* TO PUBLIC;
      GRANT ALL PRIVILEGES ON `test\_%`.\* TO PUBLIC;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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