$ 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)
|