Files and Environment Variables
Where MariaDB Shell keeps its configuration, history, logs, and installed files, and the environment variables it reads.
User Configuration Directory
MariaDB Shell keeps per-user files in its user configuration directory. The shell creates the directory the first time it runs.
Linux and macOS
~/.mariadb-shell
Windows
%AppData%\MariaDB\mariadb-shell
To use a different directory, set the MARIADB_SHELL_USER_CONFIG_HOME environment variable. This is useful to keep separate configurations, for example for testing:
MARIADB_SHELL_USER_CONFIG_HOME=/tmp/msh-test mariadb-shell --pyThe directory can contain the following files and subdirectories:
history.sql, history.py
Command history of SQL mode and Python mode. The shell saves the history when it exits while the history.autoSave option is enabled, which is the default. See Editing and History.
options.json
Configuration options that you saved with \option --persist or shell.options.set_persist(). See Configuration Options.
prompt.json
A custom prompt theme. When present, it replaces the default theme. See Prompt.
mariadb-shellrc.py
A Python startup script. It runs when Python mode is first initialized, either at startup or at the first switch to Python mode. See Startup Scripts.
init.d/
Python files that the shell loads at startup, for example to register reports.
plugins/
User plugins, one subdirectory per plugin. See Plugins.
plugin_data/
Data that plugins store, one subdirectory per plugin. plugin_data/mcp_plugin/settings.json holds the allowed paths of the MCP server; plugin_data/msm_plugin/ holds the Schema Management working directory, deployment log, and backups.
mariadb-shell.log
The shell log. Use --log-file to write it elsewhere. See Logging and Debugging.
Sandbox Directory
By default, sandbox instances are created in the sandboxes subdirectory of the default user configuration directory:
Linux and macOS
~/.mariadb-shell/sandboxes
Windows
%USERPROFILE%\MariaDB\mariadb-shell\sandboxes
This location is controlled by the sandboxDir configuration option. Its default follows MARIADB_SHELL_USER_CONFIG_HOME: with the variable set, sandboxes go to $MARIADB_SHELL_USER_CONFIG_HOME/sandboxes.
Other Files
/etc/my.cnf, /etc/mysql/my.cnf, ~/.my.cnf
Option files, read in this order. The shell reads the [mariadb-shell], [mysqlsh], and [client] groups. To list the files that a build reads, run mariadb-shell --help. See Option Files and Login Paths.
~/.mylogin.cnf
The login file, where the login-path credential store helper keeps passwords. On Windows, the file is %AppData%\MySQL\.mylogin.cnf. See Credential Store.
/etc/mysql/mariadb-shell/mariadb-shellrc.py
A system-wide startup script, run before the user's own. Windows ignores system-wide startup scripts.
Installation Directories
The installation scripts place each version in its own directory:
Linux and macOS
~/.local/share/mariadb-shell/<version>
Links mariadb-shell and msh in ~/.local/bin
Windows
%LOCALAPPDATA%\Programs\mariadb-shell\<version>
mariadb-shell.cmd and msh.cmd in %LOCALAPPDATA%\Programs\mariadb-shell\bin
Inside an installation directory, bin/ holds the executables, lib/ the private libraries, the bundled Python runtime, and the built-in plugins, and share/mariadb-shell/ the data files, such as the sample prompt themes and a startup script location for all users of that installation. The shell locates these directories relative to its executable; you can override the installation root with MARIADB_SHELL_HOME.
Environment Variables
MariaDB Shell reads the following environment variables. Each variable is also accepted under its MySQL Shell name, with the MYSQLSH_ prefix instead of MARIADB_SHELL_, for example MYSQLSH_PROMPT_THEME. The shell reads the MYSQLSH_ name only when the MARIADB_SHELL_ name is not set. A variable that is set to an empty value counts as set.
MARIADB_SHELL_USER_CONFIG_HOME
MARIADB_SHELL_HOME
The root of the installation, the directory that contains bin, lib, and share. When it is not set, the shell derives it from the location of its executable.
MARIADB_SHELL_PROMPT_THEME
The path to a prompt theme file. It takes precedence over prompt.json. If the file does not exist, the shell prints a note and uses the default prompt. An empty value selects the default prompt. See Prompt.
MARIADB_SHELL_TERM_COLOR_MODE
The color capability of the terminal: rgb, 256, 16, or nocolor. When it is not set, the shell detects the capability from the terminal.
MARIADB_SHELL_CREDENTIAL_STORE_HELPER
The credential store helper, equivalent to --credential-store-helper. See Credential Store.
MARIADB_SHELL_CREDENTIAL_STORE_SAVE_PASSWORDS
When to save passwords: always, prompt, or never. Equivalent to --save-passwords.
MARIADB_SHELL_CREDENTIAL_STORE_KEYCHAIN
On macOS, the keychain that the keychain helper uses. When it is not set, the helper uses the default keychain.
MARIADB_SHELL_MMAP
Whether the shell memory-maps local files that it reads, such as dump files: on (default), off, or required.
The shell also reads these variables:
PAGER
The default value of the pager option. See Pager.
EDITOR, VISUAL
The editor that \edit starts. When neither is set, the shell uses vi, or notepad.exe on Windows.
MARIADB_SANDBOX_BOILERPLATE_DIR, MARIADB_SANDBOX_NO_SYNC
Settings for sandbox deployment. See Sandbox Instances.
The installation scripts read their own MARIADB_SHELL_TAG, MARIADB_SHELL_PREFIX, MARIADB_SHELL_BINDIR, and related variables, which the shell itself ignores. See Linux and macOS and Windows.
This page is licensed: GPLv2
Last updated
Was this helpful?

