Connecting to MariaDB

Connecting to MariaDB

Watch the video

1. On the Gateway Webpage, go to the Config section.

2. Scroll down to Databases > Connections.

   

3. Click on Create new Database Connection...

   

4. Select the MariaDB driver and click Next.

5. On the New Database Connection page, enter the following information:

   • Name: MariaDB (or use a meaningful name for this connection)

   • Connect URL: jdbc:mariadb://localhost:3306/myDB

   

   Where localhost is the IP address or hostname of the machine with MariaDB installed, for example: localhost, 192.168.1.1, db-server, etc.

   myDB specifies the name of the database in MariaDB you want Ignition to connect to. If you're uncertain which database to connect to, speak with your local database administrator.

6. To configure the connection, Ignition needs credentials to connect to MariaDB. The Username and Password fields are where you provide credentials for a user that Ignition will use to authenticate against the database. The user should be able to do the following:

   1. Create and drop tables within the schema
   2. Alter tables within the schema
   3. Insert, update, select, and delete rows from tables in the schema
   4. Create, alter, and execute stored procedures within the schema

7. After entering a username and password, click on Create New Database Connection at the bottom of the form. Your connection is now created and the Database Connections page is displayed showing the Status of your connection as Valid.