Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1, 10.2, 10.3, 10.4
-
None
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.