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

Activated simple password check does not allow to create user identified via unix_socket

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.2.26, 10.3.25
    • N/A
    • Server
    • None

    Description

      Same as: MDEV-20631

      But for 10.2 and 10.3 where it does not seem to be the fix as in 10.4.

      MariaDB [(none)]> CREATE USER IF NOT EXISTS 'claudio'@'localhost' IDENTIFIED VIA unix_socket;
      ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
      

      As workaround I have found this:

      MariaDB [(none)]> CREATE USER IF NOT EXISTS 'claudio'@'localhost' IDENTIFIED BY 'Abcdefgh_0123456';
      Query OK, 0 rows affected (0.001 sec)
       
      MariaDB [(none)]> ALTER USER claudio@localhost IDENTIFIED VIA unix_socket;
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> Bye
      [claudio@tossanc 10323]$ bin/mysql --socket=data/10323.sock
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 21
      Server version: 10.3.23-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> select current_user(),user();
      +-------------------+-------------------+
      | current_user() | user() |
      +-------------------+-------------------+
      | claudio@localhost | claudio@localhost |
      +-------------------+-------------------+
      1 row in set (0.000 sec)
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              claudio.nanni Claudio Nanni
              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.