NCID-MYSQL-SETUP(8)

✨ NAME ✨

ncid-mysql-setup — the lil setup script that gets your MySQL/MariaDB database looking cute for the ncid-mysql output module 💖 (it lives in the NCID manual, section 8, for the record 🫶)

---

🌸 SYNOPSIS 🌸

ncid-setup mysql <authentication>

---

💅 DESCRIPTION 💅

okay so, bestie, listen: the ncid-mysql-setup script is the one that initializes the MySQL or MariaDB database, table and user that the ncid-mysql output module needs. it's giving setup, it's giving foundation, it's giving main character energy ✨

🚨 but fr fr: all existing data will be erased. not "maybe", not "sort of" — erased. so know what you're doing before you run this, okay? 😭

The ncid-mysql-setup script uses the ncid-mysql.conf file for the database configuration. that's where all the config deets live, no cap 🎀

and important: you do not execute ncid-mysql-setup directly, bestie. nope. instead, you launch it like this:

ncid-setup mysql <authentication>

that's the way. periodt. 💅

---

🦋 ARGUMENTS 🦋

• <authentication> — a string of options that gets passed directly to the mysql command line client (and yeah, it's called mysql for both MySQL and MariaDB, iconic behavior honestly 🌈).

it has to specify a user and password (if one's needed) that has MySQL or MariaDB administrative privileges. like, the keys to the kingdom, yk? 👑

this is usually a MySQL or MariaDB user called 'root'. and no, it is not the same as the 'root' login for this machine — totally different root, don't get it twisted 🙈

typically you would type:

ncid-setup mysql -u root

or:

ncid-setup mysql -u root -p<password>

or:

ncid-setup mysql -u root --password=<password>

if a password is required for the administrative login, you must specify it on the command line. no skipping, no shortcuts, that's just the vibe 💀

---

🌟 REQUIREMENTS 🌟

• Network access to a MySQL or MariaDB database server. gotta be able to reach it, bestie 🌐
• The MySQL or MariaDB command line client mysql. yes, you actually need the client 🎀
• A configured ncid-mysql.conf file. config first, chaos later ✨

---

🍓 FILES 🍓

prefix3=/etc/ncid/conf.d/ncid-mysql.conf
/usr/share/ncid/setup/ncid-mysql-setup
/usr/bin/ncid-setup

---

💜 SEE ALSO 💜

ncid-mysql.1, ncid-setup.1, ncidd.8, ncid_modules.7, ncid.1

go read those too, iykyk 📚

---

and that's the whole page, bestie!! this one's from the NCID manual, dated 2022-11-8 — so like, a certified classic at this point 👑 mwah, go set up that database, you got this 💖✨🎀🦋