Table of Contents
MySQL DB Connector
Purpose
- This allows to create a connector to a MYSQL database and use it to store admin or tenant data
- Make sure to create the target database before
Create database and user
- Log into your MYSQL DB then run the following:
CREATE DATABASE <DB_NAME>; CREATE USER '<user>'@'%' identified by '<password>'; GRANT ALL PRIVILEGES ON <DB_NAME>.* TO '<user>'@'%';
Create the connector
- Create the connector and fill up the form:
| Parameter | Description |
|---|---|
| Title | The display name of the MySQL db connector |
| Description | Description of MySQL db connector |
| Host: | The hostname or IP address of MySQL server |
| Port: | The port used by MySQL server |
| Database name: | Database used by the MySQL db connector |
| User/Password: | Credentials to access the MySQL Server |
| Primary DB: | To activate for the Primary DB |
| Initialize db: | To activate for new databases |