MYSQLROUTER_PASSWD(1)

📦
version 9.7.2_2 · 2 versions
, in arch rolling

💅 MYSQLROUTER_PASSWD — the MySQL Router Password Tool (yes bestie, that one)

okay so the manual name is MYSQLROUTER_PASSWD(1) and it lives in the MySQL Router fam — welcome to the password tool era 🎀

✨ SYNOPSIS ✨

mysqlrouter_passwd [options]

literally that's the whole synopsis. short and iconic, as she should be 💅

🌸 DESCRIPTION 🌸

mysqlrouter_passwd is a command-line app that manages the accounts in the passwd file. if you wanna see it in action, peek at Section 6.1, “A Simple MySQL Router REST API Guide” — that's the glow-up tutorial 🦋

here's the usage info, verbatim, because she ate:

Usage
  bin/mysqlrouter_passwd [opts] <cmd> <filename> [<username>]
  bin/mysqlrouter_passwd --help
  bin/mysqlrouter_passwd --version
Commands
  delete
      Delete username (if it exists) from <filename>.
  list
      list one or all accounts of <filename>.
  set
      add or overwrite account of <username> in <filename>.
  verify
      verify if password matches <username>'s credentials in <filename>.
Options
  -?, --help
      Display this help and exit.
  --kdf <name>
      Key Derivation Function for 'set'. One of pbkdf2-sha256, pbkdf2-sha512,
      sha256-crypt, sha512-crypt. default: sha256-crypt
  -V, --version
      Display version information and exit.
  --work-factor <num>
      Work-factor hint for KDF if account is updated.

🫶 COMMANDS 🫶

so the commands go command → filename → optional username, and here's what each one does 💖

  • delete — removes username from <filename>, but only if she actually exists there. no ghosting errors, she just vibes.
  • list — lists one account, or all the accounts, in <filename>. the roster reveal 👑
  • set — adds or overwrites the account for <username> in <filename>. main character energy, she takes the spot.
  • verify — checks if the password matches <username>'s credentials in <filename>. the vibe check of the whole tool 🔥

⭐ OPTIONS ⭐

  • -?, --help — shows this help and exits. classic, helpful, slay.
  • --kdf name — the Key Derivation Function used by set. it's one of pbkdf2-sha256, pbkdf2-sha512, sha256-crypt, sha512-crypt. default is sha256-crypt 💜
  • -V, --version — displays version info and exits. drop the number, dip.
  • --work-factor num — a work-factor hint for the KDF, used if the account gets updated. (hint hint, bestie — it's a hint 🍓)

Copyright © 2006, 2026, Oracle and/or its affiliates.

okay so the legal bit, and it's giving very important, so read it fr fr:

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 💀 (yes, that's the all-caps part, and yes you should take it seriously)

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-1301 USA or see http://www.gnu.org/licenses/. 🧚

🌈 AUTHOR 🌈

Oracle Corporation (http://dev.mysql.com/). periodt.

and that's the whole page, bestie 🦋 — this was MySQL 9.7, dated 06/24/2026, aka the MYSQLROUTER_PASSWD(1) manual entry. take a screenshot, tell your friends, go manage those passwd accounts responsibly 💖✨

📦 where this page comes from