MARIADB-SE...NSTALLATION(1)

💖 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 🎀

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 💖🦋