Connect to MariaDB

Prerequisites

• You have a running instance of STACKIT MariaDB. If not, you can start with Create and manage instances for MariaDB.
• You have a user with proper permissions for the MariaDB database in your instance. If not, you can create one with Create and manage credentials for MariaDB

Connect to your MariaDB instance

mariadb

The preferred way to install the mariadb client tools is the package manager of your system. For Microsoft Windows you need to download MariaDB and select the appropriate client installation options.

After installing, open a shell of your choice and connect to your database. The mariadb command does not support the connection string format. You need the port, endpoint, database, username and the password of your instance to provide the necessary flags. You can look up all these parameters in the Credentials tab of your instance. You need to extract the port and the database from the connection string.

To extract the port and the database from the connection string, you need to copy the desired information according to the format. The connection string has the following format:

mysql://<USERNAME>:<PASSWORD>@<ENDPOINT>:<PORT>/<DATABASE>

mariadb --host <ENDPOINT> --port <PORT> --user <USERNAME> --database <DATABASE> --password

Please ensure to use the custom port of your instance. You can find it in the connection string.

If you receive

ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 104

,double-check your ACL settings.

When your console shows something like this, you are connected successfully:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 585363
Server version: 10.11.12-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [mad30dc70]>

Press Control + D to close the connection and return to your command prompt.

mycli

mycli is a CLI tool to access the database. Follow the instructions on mycli’s install page or install it from the sources of your operating system.

After installing, open a shell of your choice and connect to your database. Mycli supports the connection string format. Copy the connection string you saved in the user creation step and use it in conjunction with the mycli-command.

mycli <Connection String>

The CLI will answer with something like this:

dc70-1.data.eu01.onstackit.cloud:49271/mad30dc70
MariaDB 10.11.12
mycli 1.38.3
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Thanks to the contributor - Open Query Pty Ltd
a9s87adfa95ea09124e3034355524d2@mad30dc70-1.data.eu01.onstackit.cloud
(MariaDB):mad30dc70>

Press Control + D to close the connection and return to your command prompt.