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

remove mysql.user.password column

Details

    Description

      mysql.user.password column is redundant and it's removed from mysql-5.7.

      we should remove it too, but old mysql.user tables (with the password column) should still be supported.

      • mysql_system_tables
      • mysql_fix_privilege_tables
      • sql_acl.cc
        • loading
        • insert/update user

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-17658 change the structure of mysql.user table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-11340 Allow multiple alternative authentication methods for the same user

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16774 SET PASSWORD and ALTER USER with slightly different results

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment -

            Why was this closed?

            danblack Daniel Black added a comment - Why was this closed?
            serg Sergei Golubchik added a comment -

            because the new mysql.global_priv table has no password column and the mysql.user view is frozen at the structure of 10.3, it's not supposed to be changed anymore.

            serg Sergei Golubchik added a comment - because the new mysql.global_priv table has no password column and the mysql.user view is frozen at the structure of 10.3, it's not supposed to be changed anymore.

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 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.