Thanks! Interestingly, I get slightly different results:
$ podman run --interactive --network host --tty --rm --shm-size=1G -e DISPLAY=$DISPLAY --volume=$PWD:/tmp/run --workdir=/tmp/run debian:bookworm bash # apt-get update && apt-get install -y mariadb-server # service mariadb start # dpkg -l mariadb-server --no-pager | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++-==============-====================-============-================================= ii mariadb-server 1:10.11.11-0+deb12u1 amd64 MariaDB database server binaries # mariadb -e "SHOW VARIABLES LIKE '%collation%';" +----------------------+--------------------+ | Variable_name | Value | +----------------------+--------------------+ | collation_connection | latin1_swedish_ci | | collation_database | utf8mb4_general_ci | | collation_server | utf8mb4_general_ci | +----------------------+--------------------+ # echo 'deb http://deb.debian.org/debian sid main' > /etc/apt/sources.list # apt-get full-upgrade -y # mariadb -e "SELECT count(*) FROM mysql.user WHERE user='root' and password='' and password_expired='N' and plugin in ('', 'mysql_native_password', 'mysql_old_password');" +----------+ | count(*) | +----------+ | 0 | +----------+ # mariadb -e "SHOW VARIABLES LIKE '%collation%';" +--------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +--------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+ | character_set_collations | utf8mb3=utf8mb3_uca1400_ai_ci,ucs2=ucs2_uca1400_ai_ci,utf8mb4=utf8mb4_uca1400_ai_ci,utf16=utf16_uca1400_ai_ci,utf32=utf32_uca1400_ai_ci | | collation_connection | latin1_swedish_ci | | collation_database | utf8mb4_uca1400_ai_ci | | collation_server | utf8mb4_uca1400_ai_ci | +--------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+
