Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2.26, 10.3.25
-
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
- is duplicated by
-
MDEV-20631 Activated simple password check does not allow to create user identified via unix_socket
- Closed