Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.22
-
None
-
None
Description
$ podman run -e MARIADB_ROOT_PASSWORD=hohum -d mariadb:10.4
|
|
$ podman exec -ti clever_antonelli mysql -phohum
|
|
MariaDB [(none)]> show create user;
|
+---------------------------------------------------------------------------------------------------+
|
| CREATE USER for root@localhost |
|
+---------------------------------------------------------------------------------------------------+
|
| CREATE USER `root`@`localhost` IDENTIFIED BY PASSWORD '*B0D72986672390CF3C294D28B2024176FDC0BA94' |
|
+---------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> alter user root@localhost identified via unix_socket or mysql_native_password;
|
Query OK, 0 rows affected (0.003 sec)
|
|
MariaDB [(none)]> show create user;
|
+------------------------------------------------------------------------------------+
|
| CREATE USER for root@localhost |
|
+------------------------------------------------------------------------------------+
|
| CREATE USER `root`@`localhost` IDENTIFIED VIA unix_socket OR mysql_native_password |
|
+------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> set password for root@localhost='*B0D72986672390CF3C294D28B2024176FDC0BA94';
|
Query OK, 0 rows affected (0.019 sec)
|
|
MariaDB [(none)]> show create user root@localhost;
|
+--------------------------------------------------------------------------------------------------------------------------------------+
|
| CREATE USER for root@localhost |
|
+--------------------------------------------------------------------------------------------------------------------------------------+
|
| CREATE USER `root`@`localhost` IDENTIFIED VIA unix_socket USING '*B0D72986672390CF3C294D28B2024176FDC0BA94' OR mysql_native_password |
|
+--------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> select version();
|
+---------------------------------------+
|
| version() |
|
+---------------------------------------+
|
| 10.4.22-MariaDB-1:10.4.22+maria~focal |
|
+---------------------------------------+
|
1 row in set (0.001 sec)
|
We end up with a password set on unix_socket, not mysql_native_password.