otty / dotfiles

All tools/MySQL

MySQL

mysql

mysql is a simple SQL shell with input line editing capabilities.

Detected by mysql | macOS, Linux, Windows |dev.mysql.com

Sync it mysql.toml

Sync rules

What travels, what stays, what never leaves

MySQL in your home directory Every rule on this page, by file

…

user = octocat

host = db.example.com

port = 3306

socket = /tmp/mysql.sockmachine-local

password = "FAKEclientPassword"

default-character-set = utf8mb4

…

Each machine keeps its own copy of these.

password

Lifted into your secret store; the rest of the file syncs.

· ~/.mysql_history Exclude

· ~/.mylogin.cnf Never synced

· %APPDATA%/MySQL/.mylogin.cnf Never synced

Only what the catalog names. A directory that syncs brings everything inside it except what is listed as excluded here.

apps/mysql.tomlThe file this page is generated from

id = "mysql"

name = "MySQL"

homepage = "https://dev.mysql.com/doc/refman/8.4/en/mysql.html"

description = "mysql is a simple SQL shell with input line editing capabilities."

icon = "SimpleIcons:mysql"

detect = ["mysql"]

# https://dev.mysql.com/doc/refman/8.4/en/option-files.html — the two

# user-level option files are "~/.my.cnf User-specific options" and

# "~/.mylogin.cnf User-specific login path options (clients only)". The same

# page puts .mylogin.cnf "in the %APPDATA%\MySQL directory on Windows and in

# the current user's home directory on non-Windows systems". ~/.my.cnf is

# listed for Unix only; the Windows option files (%WINDIR%\my.ini, C:\my.ini,

# INSTALLDIR\my.ini) are system-wide, so they are not here.

paths = ["~/.my.cnf"]

# The client history: every statement typed at the mysql prompt, which is where

# an ad-hoc CREATE USER ... IDENTIFIED BY lands.

exclude = ["~/.mysql_history"]

# https://dev.mysql.com/doc/refman/8.4/en/mysql-config-editor.html — a login

# path is "an option group that permits only certain options: host, user,

# password, port and socket", written obfuscated by mysql_config_editor. The

# whole file exists to hold credentials.

# The fixture copies are plain text stand-ins: the real file is a binary blob

# no fixture can carry, and nothing parses a whole-file secret.

secret = [

"~/.mylogin.cnf",

"%APPDATA%/MySQL/.mylogin.cnf",

]

# Read once at client startup by a process that then exits.

side_effect = false

# The docs' own example of ~/.my.cnf is a [client] group with

# password="my password" in it — a plaintext password in an otherwise ordinary

# INI of client preferences (prompt, pager, default-character-set), so the file

# is synced and this one key is lifted out.

[[secret_paths]]

file = "~/.my.cnf"

match = { prefix = ["password"] }

# socket names the Unix socket file the local server listens on — /tmp/mysql.sock

# on one machine, /var/run/mysqld/mysqld.sock on the next.

# Which path the socket sits at is decided by the packaging for this kind of

# machine, so the value holds across every box of the same OS and architecture.

[[machine_lines]]

file = "~/.my.cnf"

match = { prefix = ["socket"] }

scope = "platform"

Use it with your dotfile manager

Same data, in the shape your tool already reads

Opens Otty and adds this tool to what it syncs

Opens otty://sync/add/mysql. Otty ships with this catalog, so the link only has to name the tool — nothing is downloaded.

Every one of these keeps all credential files out. None of them splits socket for you — that part is Otty’s own sync, or a template you write by hand.