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

ERROR 1819 on grant statment for existing user

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.9
    • 10.1.11
    • Authentication and Privilege System
    • None
    • Linux with parameters set:
      plugin-load-add=simple_password_check.so
      simple_password_check_other_characters=0
    • 10.1.11

    Description

      For statements:

      CREATE USER 'usergoodmixed'@'%' IDENTIFIED BY 'Hi123456';
      		 
      GRANT select  ON  performance_schema.users to  'usergoodmixed'@'%'

      I get error :

      ERROR 1819 (HY000) at line 25 in file: 'password_complexity_test.sql': Your password does not satisfy the current policy requirements

      on the grant statement.
      I see a MySQL Bug:
      https://bugs.mysql.com/bug.php?id=70451
      Is this issue addressed with MariaDB?

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          aferrett Andy Ferretti added a comment -

          I haven't seen any response to this. Is there something that I need to do to notify of this issue? I noticed that MySQL does not have this problem, so this creates an inconsistency between MySQL and MariaDB.

          aferrett Andy Ferretti added a comment - I haven't seen any response to this. Is there something that I need to do to notify of this issue? I noticed that MySQL does not have this problem, so this creates an inconsistency between MySQL and MariaDB.
          serg Sergei Golubchik added a comment -

          No, thanks, you don't need to do anything — creating an issue is enough.

          serg Sergei Golubchik added a comment - No, thanks, you don't need to do anything — creating an issue is enough.
          aferrett Andy Ferretti added a comment -

          It looks like this is fixed for 10.1.11 when it comes available.

          aferrett Andy Ferretti added a comment - It looks like this is fixed for 10.1.11 when it comes available.
          Manasa ManasaTulluri added a comment -

          Hi,

          I am using version 10.1.10-MariaDB . I did not face this issue in Windows OS. But with the same 10.1.10 version in Linux I face ERROR 1819 with grant and revoke statements
          Could you please let me know what is the solution?

          Thanks & Regards,
          Manasa Tulluri.

          Manasa ManasaTulluri added a comment - Hi, I am using version 10.1.10-MariaDB . I did not face this issue in Windows OS. But with the same 10.1.10 version in Linux I face ERROR 1819 with grant and revoke statements Could you please let me know what is the solution? Thanks & Regards, Manasa Tulluri.
          aferrett Andy Ferretti added a comment -

          The people at MariaDB fixed this with 10.1.11.

          aferrett Andy Ferretti added a comment - The people at MariaDB fixed this with 10.1.11.

          People

            serg Sergei Golubchik
            aferrett Andy Ferretti
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.