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:
              Unassigned
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: