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

Users identified via ed25519 are non-functional without password

    XMLWordPrintable

Details

    Description

      Note: Possibly it's just a documentation problem, currently the plugin page doesn't say anything on the subject.

      A user identified via ed25519 can be created without a password. It is accepted without errors or warnings:

      MariaDB [test]> create user foo@localhost identified via ed25519;
      Query OK, 0 rows affected (0.02 sec)
       
      MariaDB [test]> select user, host, password, authentication_string from mysql.user where user = 'foo';
      +------+-----------+----------+-----------------------+
      | User | Host      | Password | authentication_string |
      +------+-----------+----------+-----------------------+
      | foo  | localhost |          |                       |
      +------+-----------+----------+-----------------------+
      1 row in set (0.00 sec)
      

      However, such user cannot connect:

      $ bin/mysql --protocol=tcp --port=3308 -ufoo 
      ERROR 1045 (28000): Access denied for user 'foo'@'localhost' (using password: NO)
       
      $ bin/mysql --protocol=tcp --port=3308 -ufoo -p
      Enter password: 
      ERROR 1045 (28000): Access denied for user 'foo'@'localhost' (using password: NO)
      

      In 10.4 it reports "using password: YES" instead of "using password: NO", but otherwise the result is the same.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.