gistfile1.txt

$ podman run -d --rm -e MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=1  mariadb:10.5.10
Resolved "mariadb" as an alias (/home/dan/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/library/mariadb:10.5.10...
Getting image source signatures
Copying blob e989e430508e skipped: already exists  
Copying blob 26ea6552a462 skipped: already exists  
Copying blob c549ccf8d472 skipped: already exists  
Copying blob 9f8d09317d80 skipped: already exists  
Copying blob 2bc055a5511d skipped: already exists  
Copying blob 329b1f41043f skipped: already exists  
Copying blob f0e596ee38c5 done  
Copying blob cc09fec0bce1 done  
Copying blob 1c9b9043bdda done  
Copying blob 201c98fa16f6 done  
Copying config 104f4e7cbe done  
Writing manifest to image destination
Storing signatures
bfce1a78cb0b0e2cf6c173a5376afe82b523561a181664184eb0126b64a84cdc


$ podman exec -ti bfce1a78cb0b0e2cf6c173a5376afe82b523561a181664184eb0126b64a84cdc  mariadb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.5.10-MariaDB-1:10.5.10+maria~focal mariadb.org binary distribution

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)]> create user user1 identified by 'PBvh;(e852QXhoCbI6?';
Query OK, 0 rows affected (0.021 sec)

MariaDB [(none)]> alter user user1 identified by 'a';
Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> Bye

$ podman exec -ti bfce1a78cb0b0e2cf6c173a5376afe82b523561a181664184eb0126b64a84cdc  mariadb -u user1 -pa
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.5.10-MariaDB-1:10.5.10+maria~focal mariadb.org binary distribution

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();
+----------------+
| current_user() |
+----------------+
| user1@%        |
+----------------+
1 row in set (0.000 sec)