MySQL Root
Last updated
Last updated
The MySQL Root Integration allows the SaaS system to perform database-level operations using root or privileged MySQL credentials. This integration is essential for provisioning new databases and users dynamically during tenant creation—especially when using multi-database or isolated-DB schemes.
This feature is useful in dedicated servers or VPS environments where the system has full control over the MySQL service.
The settings for MySQL root access are available under the MySQL Root tab in the settings section.
MySQL Enabled
Toggle to enable or disable MySQL root integration. If disabled, the system will use the current default MySQL connection.
MySQL Host
The hostname or IP address of your MySQL server (e.g., 127.0.0.1 or mysql.domain.com).
MySQL Port
The port used by MySQL (default is 3306).
MySQL Username
A MySQL user with root-level privileges, capable of creating new databases and users.
MySQL Password
The password for the root or privileged user.
Create MySQL User
When enabled, the system will create a separate MySQL user for each tenant and assign it to their newly created database.
When creating a new tenant with a "Create a new database" or "I will provide my own credentials" option, this integration allows the system to:
Automatically create a new database for the tenant.
Create a new MySQL user (if enabled).
Assign appropriate privileges to the user for the new database.
The credentials are securely used server-side and are not exposed to the front end or the tenant.
Note: If the MySQL Root integration is disabled or credentials are not provided, the system will fall back to using the current active database connection configured in the Concord CRM
.envfile.
This fallback is helpful when you're using a single-database, table-prefix-based multi-tenancy model or for quick testing in shared hosting environments.
Use a separate MySQL user with scoped privileges if full root access is not required.
