MARIADB-SETPERMISSION(1)

💖 MARIADB-SETPERMISSION 💖

okay bestie, welcome to the MariaDB Database System corner of the manual pages — this one's MARIADB-SETPERMISSION(1) and it's lowkey a whole vibe. ✨

---

🌸 NAME 🌸

mariadb-setpermission — the little interactive bestie that sets your permissions in the grant tables for you 🫶

not me realizing mariadb-setpermission is now a symlink to mariadb-setpermission 💀 iconic circular queen behavior, no notes

---

✨ SYNOPSIS ✨

mariadb-setpermission [options]

---

🦋 DESCRIPTION 🦋

okay so. mariadb-setpermission is a Perl script — originally written and contributed by Luuk de Boer — and what it does is interactively set permissions in the MariaDB grant tables. it's literally written in Perl and it requires that the DBI and DBD::MariaDB Perl modules be installed, so pls make sure you've got those or it's not gonna go. 💅

invoke it like this, bestie:

shell> mariadb-setpermission [options]

and those options should be either --help to display the help message, or options that say how to connect to the MariaDB server. 🌈 and here's the tea: the account you connect with decides which permissions you have when you're trying to modify existing permissions in the grant tables. so like, choose wisely, main character. 👑

also — mariadb-setpermission reads options from the [client] and [perl] groups in the .my.cnf file in your home directory, if that file exists. sneaky little config reader, obsessed. 🎀

mariadb-setpermission supports the following options:

• --help — displays a help message and then exits. polite king behavior. ✨
• --host=host_name — connect to the MariaDB server on the given host. host_name is the host, bestie. 📍
• --password=password — the password to use when connecting to the server. 🩷 heads up though: the password value is not optional for this option, unlike for other MariaDB programs — so you can't just vibe and skip it.

⚠️ specifying a password on the command line should be considered insecure. you can use an option file to avoid giving the password on the command line. protect the password, bestie, fr fr 😭

• --port=port_num — the TCP/IP port number to use for the connection. 🔌
• --socket=path — for connections to localhost, the Unix socket file to use. 🐍
• --user=user_name — the MariaDB user name to use when connecting to the server. user_name goes in, you know the drill. 💜

---

👑 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. (translation: it's giving no promises, bestie 🫠)

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 🔥

for more information, please refer to the MariaDB Documentation, available online at https://mariadb.com/docs/ — go read it, iykyk 📚✨

---

💜 AUTHOR 💜

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

---

and that's the whole page, bestie — you ate that. this was MariaDB 11.8, dated 5 March 2025, straight from the MARIADB-SETPERMISSION(1) manual. periodt. 💅✨🎀