Connecting to a Server
How MariaDB Shell connects to MariaDB Server: connection URIs, local sockets, option files, TLS, SSH tunnels, compression, and stored passwords.
MariaDB Shell connects to MariaDB Server, and to MySQL servers, over the classic client/server protocol through MariaDB Connector/C. You describe the target with a connection URI such as mariadb://dba@db1.example.com:3306/shop, with a dictionary of connection options in Python, or with command-line options such as -h, -P, and -u.
The pages in this section explain each part of a connection, from the URI syntax to tunnels and stored passwords.
To open a first connection and learn how the global session works, see Sessions.
The URI syntax with the mariadb:// scheme, connection dictionaries, the connection command-line options, and which setting wins when they overlap.
Local connections through a Unix socket file, or through a named pipe on Windows.
The option files and groups that MariaDB Shell reads at startup, and how it uses ~/.mylogin.cnf.
The TLS modes and how they behave against MariaDB Server, certificates, revocation lists, ciphers, and protocol versions.
Reaching a server through SSH with a mariadb+ssh:// URI or with the --ssh options.
Turning on protocol compression for slow or metered links.
How MariaDB Shell remembers passwords and other secrets, the helper used on each platform, and the functions that manage stored entries.