🐬

MySQL

Complete MySQL and MariaDB compatibility

Connection Settings

Field	Description	Example
Host	Database server hostname or IP	localhost
Port	MySQL port (default: 3306)	3306
Database	Database name to connect to	myapp_production
Username	Database user	analytics_user
Password	User password (encrypted at rest)	••••••••

Features

All MySQL Versions

MySQL 5.7, 8.0+ and MariaDB 10.x fully supported

SSL/TLS Encryption

Secure connections with certificate verification

Connection Pooling

Efficient connection management for high performance

Character Sets

Full UTF-8 and international character support

SSL Configuration

For secure connections, enable SSL and optionally provide certificates:

# Enable SSL in connection settings
SSL Mode: Required

# Optional: Provide CA certificate
CA Certificate: /path/to/ca-cert.pem

# Optional: Client certificate (for mutual TLS)
Client Certificate: /path/to/client-cert.pem
Client Key: /path/to/client-key.pem

Recommended Permissions

For read-only analytics, create a dedicated user:

CREATE USER 'dbcraft_reader'@'%' IDENTIFIED BY 'secure_password';
GRANT SELECT ON mydb.* TO 'dbcraft_reader'@'%';
FLUSH PRIVILEGES;