GOLF(2gg)

💖 GOLF(2gg) — mariadb-database 💖

okay bestie, welcome to the golf manual, section 2gg ✨ this is the development corner of the docs and we're about to talk about your MariaDB database config. no cap.

---

🌸 NAME 🌸

mariadb-database — Golf documentation (database) 🎀

---

✨ DESCRIPTION ✨

so the MariaDB configuration file is literally written as a MariaDB client options file. that's the whole vibe. 💅

you can peep all the parameters that exist over at https://mariadb.com/kb/en/configuring-mariadb-connectorc-with-option-files/#options 👑

but lowkey? most of the time you're only gonna use a few of those options. fr fr. like, for a local connection it's giving:

[client]
user=myuser
password=mypwd
database=mydb
socket=/run/mysqld/mysqld.sock

okay so let's break down that file because it's iconic:

• user — the MariaDB user 🫶
• password — the password for that MariaDB user
• database — the MariaDB database name
• socket — where the MariaDB communication socket lives (this assumes your database is local to your computer! if your database is across the network you would not use sockets, bestie 😭)

if you use passwordless MariaDB login (like when your MariaDB user name is the same as your Operating System user name, and the unix socket plugin is what's handling authentication), then the password would just be empty. yes, empty. main character energy. ✨

to get the location of the socket, you might use:

sudo mysql -u root -e "show variables like 'socket'"

slay. now you know where your socket's at. 🌈

---

🦋 SEE ALSO 🦋

Database

begin-transaction commit-transaction current-row database-config-file db-error mariadb-database postgresql-database rollback-transaction run-query sqlite-database See all documentation 💜

---

and that's the whole page, bestie!! this lil' cutie came from version $VERSION and it's dated $DATE — the GOLF(2gg) era, periodt. 💖✨🎀