MariaDB default users, databases and permissions in various distros

Hi! There are a lot of guides online that recommend running mysql_secure_installation (or MariaDB equivalent mariadb-secure-installation). On Debian/Ubuntu this script is pretty much useless, but in https://dba.stackexchange.com/questions/346696/should-dbas-stop-running-mysq... a commenter pointed out that in Fedora there are still anonymous users and a test database created on the default install. I wanted to check here on the packagers list what is your take on this? Should we try to unify that the default users and databases across various distros and packages of MariaDB would always be the same (secure) defaults so that mariadb-secure-installation can be deprecated? - Otto

I checked where the test DB and the users come from, in the case of the guy on the StackExchange, and I found out it's not the downstream Fedora package, but rather the upstream ones provided directly by MariaDB. I am strongly in favor of this unification. Michal -- Michal Schorm Software Engineer Databases Team Red Hat -- On Sat, May 31, 2025 at 9:42 AM Otto Kekäläinen via packagers <packagers@lists.mariadb.org> wrote:
Hi!
There are a lot of guides online that recommend running mysql_secure_installation (or MariaDB equivalent mariadb-secure-installation). On Debian/Ubuntu this script is pretty much useless, but in https://dba.stackexchange.com/questions/346696/should-dbas-stop-running-mysq... a commenter pointed out that in Fedora there are still anonymous users and a test database created on the default install.
I wanted to check here on the packagers list what is your take on this?
Should we try to unify that the default users and databases across various distros and packages of MariaDB would always be the same (secure) defaults so that mariadb-secure-installation can be deprecated?
- Otto _______________________________________________ packagers mailing list -- packagers@lists.mariadb.org To unsubscribe send an email to packagers-leave@lists.mariadb.org
participants (2)
-
Michal Schorm
-
Otto Kekäläinen