User Tools

Site Tools


products:cockpit.old:1.0:userguide:administration:dbconnectors:mysql

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
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/cockpit.old/1.0/userguide/administration/dbconnectors/mysql.txt · Last modified: 2024/05/01 18:39 (external edit)