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

CREATE/ALTER USER as in 5.7

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

            Ascending order - Click to sort in descending order
            cvicentiu Vicențiu Ciorbaru added a comment -

            Hi Sergei,

            I've updated the CREATE/ALTER USER syntax to work according to MySQL's. Can you please review the changes related to this MDEV? I've sent the patch on the mailing list.

            I initially tried an approach that involved a bit of refactoring. After figuring out that it is not really worth it right now, I came up with the easier implementation just calling replace_user_table.

            cvicentiu Vicențiu Ciorbaru added a comment - Hi Sergei, I've updated the CREATE/ALTER USER syntax to work according to MySQL's. Can you please review the changes related to this MDEV? I've sent the patch on the mailing list. I initially tried an approach that involved a bit of refactoring. After figuring out that it is not really worth it right now, I came up with the easier implementation just calling replace_user_table.
            cvicentiu Vicențiu Ciorbaru added a comment -

            Implemented with:
            https://github.com/MariaDB/server/compare/1a3db0e...f12229f

            cvicentiu Vicențiu Ciorbaru added a comment - Implemented with: https://github.com/MariaDB/server/compare/1a3db0e...f12229f

            People

              cvicentiu Vicențiu Ciorbaru
              serg Sergei Golubchik
              Votes:
              4 Vote for this issue
              Watchers:
              6 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.