--dsn (--url)

Overview

A formatted URL string, i.e., mariadb://user:password@hostname:port/database

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

USAGE

mariadb-shell [{--dsn | --url} <url_string>]

DETAILS

Option

Default Behavior

Argument
--dsn
--url

If omitted, MariaDB Shell does not use a DSN to connect

A formatted URL string like mariadb://DATABASE_USER:USER_PASSWORD@HOSTNAME:TCP_PORT/DATABASE/?ssl-ca=CA_CHAIN_PATH

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

To connect to a remote host using a formatted URL string:

$ mariadb-shell \
   --dsn mariadb://app_user:app_user_passwd@host.example.com:3306/test

The equivalent command is:

$ mariadb-shell \
   --url mariadb://app_user:app_user_passwd@host.example.com:3306/test

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