MYSQL-SECR...-LOGIN-PATH(1)

👑 MYSQL-SECR...-LOGIN-PATH(1) 💅

okay bestie so this page lives in the MySQL Database System manual, and the page name up top is the truncated icon herself, MYSQL-SECR...-LOGIN-PATH(1). Yes it's giving "abbreviated for the header column", no we're not fixing it, we respect the formatting ✨

---

🌸 NAME 🌸

mysql-secret-store-login-path — a secret store interface for MySQL login credentails 🫶

(yes, "credentails". the typo is canon. we love her anyway.)

---

🦋 SYNOPSIS 🦋

mysql-secret-store-login-path <version|store|get|erase|list>

---

💖 DESCRIPTION 💖

mysql-secret-store-login-path interacts with the MySQL secret store system to manage user login credentials. That's the whole job. She stores, gets, and erases secrets — and it all goes down based on JSON data you hand her through standard input. Like, you pipe JSON in, she does her lil thing, periodt. 🎀

---

✨ OPTIONS ✨

• version — displays the program version and then dips. exit stage left, we're done here 👋
• store — stores a brand new set of credentials in the secret store. This one needs JSON input through stdin containing the following fields:

{
       "ServerURL": "user@host:port",
       "SecretType": "<secret type>",
       "Secret": "<secret>"
}

• get — gets a set of credentials, based on the server URL and the secret type. The data comes back through stdout as a JSON object that matches what was stored previously. This one needs JSON input through stdin containing the following fields:

{
       "ServerURL": "user@host:port",
       "SecretType": "<secret type>"
}

• erase — removes a set of credentials, based on the server URL and the secret type. This one needs JSON input through stdin containing the following fields:

{
       "ServerURL": "user@host:port",
       "SecretType": "<secret type>"
}

• list — lists all the available credential URLs and secret types. The data is returned as a JSON list through stdout. main character behaviour fr fr 📋

---

🌈 EXAMPLES 🌈

Store credentails for local root user:

cat <<EOF | mysql-secret-store-login-path store
{
       "ServerURL": "root@localhost:3306",
       "SecretType": "password",
       "Secret": "P@ssW0rd"
}
EOF

Get credentails for local root user:

cat <<EOF | mysql-secret-store-login-path get
{
       "ServerURL": "root@localhost:3306",
       "SecretType": "password"
}
EOF

Erase credentails for local root user:

cat <<EOF | mysql-secret-store-login-path erase
{
       "ServerURL": "root@localhost:3306",
       "SecretType": "password"
}
EOF

List all credentails:

mysql-secret-store-login-path list

---

and that's the whole vibe check 🧚 no cap. this page is from MySQL 8.0, dated 23/02/2024, and it literally ate 💜 stay secret, stay stored, mwah 💋✨