MARIADB-SE...NSTALLATION(1)

📦
version 13.0.2 · 19 versions
, in alpine 3.24, arch rolling, centos-stream 10, centos-stream 9, debian trixie, fedora 43, fedora 44, nixpkgs unstable, opensuse-leap 16.0, ubuntu resolute, ubuntu stonking

💖 MARIADB-SECURE-INSTALLATION(1) 💖

okay bestie, welcome to the MariaDB Database System corner of the man pages — this one's called mariadb-secure-installation and honestly? it's giving glow-up for your database's whole security situation. 🔐✨

✨ NAME ✨

mariadb-secure-installation — improve MariaDB installation security

(also, fun lil lore drop: mariadb-secure-installation is now a symlink to mariadb-secure-installation 🫶 yes it's a symlink to itself, we don't make the rules)

🌸 SYNOPSIS 🌸

mariadb-secure-installation

💅 DESCRIPTION 💅

so like, this program lets you level up the security of your MariaDB installation, and here's the ways it does that:

  • you can set a password for root accounts 👑
  • you can remove root accounts that are accessible from outside the local host 🚪💨
  • you can remove anonymous-user accounts 🙈 (bye ghost users)
  • you can remove the test database, which by default can be accessed by anonymous users 😭 (yes, the default is that unserious)

you can invoke mariadb-secure-installation without any arguments at all, no notes:

shell> mariadb-secure-installation

then the script will literally prompt you to figure out which actions to perform — it's a whole conversation, you just answer the questions bestie 💬

mariadb-secure-installation also accepts some options:

  • --basedir=dir_name — base directory 📁
  • --defaults-extra-file=file_name — additional option file 🗂️
  • --defaults-file=file_name — option file 📄
  • --no-defaults — don't read any defaults file 🙅♀️

and any other unrecognized options? those get passed on to the server. not our problem, not our business, we're just the messenger 🧚

Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2025 MariaDB Foundation

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see http://www.gnu.org/licenses/.

🌈 SEE ALSO 🌈

want more info? go check the MariaDB Documentation, it's available online at https://mariadb.com/docs/ 📚✨

💜 AUTHOR 💜

MariaDB Foundation (http://www.mariadb.org/) 🫶

no cap, that's the whole page. go secure your install, you main character 🔥

MariaDB 11.8 — 5 March 2025 — mwah, that's a wrap, ily, go touch some grass and then come back and set that root password 💖🦋

📦 where this page comes from