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

CREATE/ALTER USER as in 5.7

    XMLWordPrintable

Details

    • 10.2.0-1, 10.2.0-2, 10.2.0-4, 10.2.0-5, 10.2.0-6, 10.2.0-7

    Description

      MySQL 5.7 has extended CREATE/ALTER USER syntax to make a better distinction between privilege management (GRANT/REVOKE) and account management (clauses like IDENTIFIED, REQUIRE SSL, MAX_QUERIES_PER_HOUR, etc). And there's SHOW CREATE USER.

      We should support this syntax too.

      Don't forget consistent use of IF [NOT] EXISTS

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-11180 CREATE USER .. IDENTIFIED WITH .. BY .. is not supported

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11181 Resource option MAX_USER_CONNECTIONS in CREATE USER is limited by 2**32

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Open

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              serg Sergei Golubchik
              Votes:
              4 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 10d Original Estimate - 10d
                  10d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 10d 2.5h
                  10d 2.5h

                  Git Integration

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