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

Users identified via ed25519 are non-functional without password

    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

            • Assignee:
              greenman Ian Gilfillan
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: