Skip to content

MariaDB

This connector provides functionality for MariaDB databases.

It is included by default in AWS/Azure/Docker/VM distributions.

Installation and Configuration

See the installation documentation for the MySQL connector; the same connector is used for MySQL and MariaDB.

Editing a Database Connection

To edit an existing database connection, go to the Database Connections list and click the Edit icon in the Actions column, or click on the database ID.

The edit form is divided into three sections: Connection, Configuration, Privileges

Connection

  • Description - an optional description for the connection
  • Type - the database vendor type
  • Database Charset - the character set used for string types
  • Database Schema - the name of the database server schema to use
  • Database Host - the hostname or IPv4 address of the database server
  • Database Port - the port number that the database server listens on
  • Database Name - the name of the database on the server to use

Configuration

  • Connect Automatically - automatically connect to the database whenever SlashDB starts

  • Cache Schema - cache the database schema after the first connection so that subsequent connections complete faster

    Important

    Whenever your database structure changes, you will need to disable this option, disconnect/reconnect, and then enable it again. If your database structure changes frequently, you may want to disable it entirely.

  • Auto Discover - automatically find all tables and views in your database whenever SlashDB connects

Database Credentials

Pick one of:

Privileges

  • Connect / Disconnect DB - users with privileges to control the database connection
  • View DB Config - users with privileges to view the database configuration
  • Modify DB Config - users with privileges to edit or delete the database configuration