--store-connection-settings

Overview

Stores current connection settings for selected profile (implies --profile,overwriting or creating a new one)

See also: mariadb-shell for MariaDB Shell, in 23.02, in 23.01, in 22.12, and in 22.10

USAGE

mariadb-shell [--store-connection-settings --profile <profile_name>]

DETAILS

Option

Default Behavior

Argument

--store-connection-settings

If omitted, MariaDB Shell does not save connection settings

The settings are saved in the ~/.msh.cnf file in the section with the name specified in the --profile option

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

To save connection settings as a profile named test:

$ mariadb-shell \
   --host host.example.com \
   --user user_name \
   --password 'user_password' \
   --database test \
   --store-connection-settings \
   --profile test

The connection settings will be saved in the .msh.cnf file under the [profile test] section:

[profile test]
host = host.example.com
user = user_name
password = PASSWORD_HASH
port = 3306
database = test
unix_socket = /run/mysqld/mysqld.sock

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.03

  • Present starting in MariaDB Shell 23.03.1.

23.02

  • Present starting in MariaDB Shell 23.02.1.

23.01

  • Present starting in MariaDB Shell 23.01.1.

22.12

  • Present starting in MariaDB Shell 22.12.1.

22.10

  • Present starting in MariaDB Shell 22.10.3.

EXTERNAL REFERENCES