Mysql

Category: Database Connectors

Introduction

This document is created to help setup a mindzieDataDesigner connector to MySQL database. The mindzieDataDesigner is the ETL tool used by mindzieStudio to convert database tables to process mining event logs. The purpose of this document is to help creating the connection string and opening ports on the firewall if required.

Overview

The MySQL connector provides native connectivity to MySQL Server instances using the official MySQL .NET Connector. This connector supports all MySQL versions and deployment scenarios including on-premise, cloud, and containerized environments.

System Requirements

• Database System: MySQL 5.7 or later (MySQL 8.0 recommended)
• Supported Editions: MySQL Community Server, MySQL Enterprise Edition
• Cloud Support: Amazon RDS for MySQL, Azure Database for MySQL, Google Cloud SQL
• Platform Support: Windows, Linux, macOS
• Dependencies: MySQL .NET Connector (MySql.Data) - included with connector

Connection String Format

Basic Format

Server=hostname;Port=3306;Database=database_name;Uid=username;Pwd=password;

Connection Parameters

Parameter	Description	Required	Example
Server or Host	MySQL server hostname/IP	Yes	mysql.company.com
Port	Server port number	No	3306 (default)
Database	Database name	Yes	process_mining
Uid or User ID	MySQL username	Yes	mindzie_user
Pwd or Password	MySQL password	Yes	SecurePassword123
Connection Timeout	Connection timeout (seconds)	No	30
Command Timeout	Command timeout (seconds)	No	600
Pooling	Enable connection pooling	No	true
Min Pool Size	Minimum pool size	No	0
Max Pool Size	Maximum pool size	No	100
SSL Mode	SSL connection mode	No	Required
CharSet or Character Set	Character encoding	No	utf8mb4

Connection Examples

Local MySQL Server

Server=localhost;Port=3306;Database=process_mining;Uid=mindzie_user;Pwd=password;

Remote MySQL Server with SSL

Server=mysql.company.com;Port=3306;Database=process_mining;Uid=mindzie_user;Pwd=SecurePassword123;SSL Mode=Required;

Amazon RDS MySQL

Server=myinstance.123456789012.us-east-1.rds.amazonaws.com;Port=3306;Database=process_mining;Uid=admin;Pwd=AWSPassword123;SSL Mode=Required;

Azure Database for MySQL

Server=myserver.mysql.database.azure.com;Port=3306;Database=process_mining;Uid=mindzie@myserver;Pwd=AzurePassword123;SSL Mode=Required;

Connection with Advanced Settings

Server=mysql-server;Port=3306;Database=process_mining;Uid=mindzie_user;Pwd=password;
Pooling=true;Min Pool Size=5;Max Pool Size=50;Connection Timeout=30;
Character Set=utf8mb4;SSL Mode=Preferred;

Troubleshooting

Common Connection Issues

"Unable to connect to any of the specified MySQL hosts" Error

• Verify server hostname and port
• Check network connectivity and firewall rules
• Ensure MySQL server is running: systemctl status mysql
• Validate MySQL bind-address configuration

"Access denied for user" Error

• Verify username and password are correct
• Check user exists: SELECT User, Host FROM mysql.user;
• Ensure user has proper privileges: SHOW GRANTS FOR 'username'@'host';
• Verify host-based access permissions

"Unknown database" Error

• Verify database name exists: SHOW DATABASES;
• Check user has access to the database
• Ensure proper database selection in connection string

SSL Connection Errors

• Verify SSL Mode setting matches server configuration
• Check MySQL SSL certificate configuration
• Use SSL Mode=None for testing (not recommended for production)

Cloud-Specific Configurations

Amazon RDS

• Use RDS endpoint as server name
• Enable SSL connections
• Configure security groups for access

Azure Database for MySQL

• Use fully qualified server names
• Include server name in username: user@servername
• Configure firewall rules for client IPs
• Enable connection security settings

mindzie Server Access: For enhanced security, you can configure your firewall to only allow connections from mindzie servers by whitelisting specific IP addresses. Contact mindzie support to obtain the current IP addresses for the mindzie servers you are using.

Google Cloud SQL

• Use public or private IP connections
• Configure authorized networks
• Enable SSL certificates for secure connections

Related Information

• Official Documentation: MySQL Documentation
• MySQL .NET Connector: MySQL Connector/NET
• Performance Tuning: MySQL Performance Tuning
• Security: MySQL Security Guide

---

💡 Tip: Use utf8mb4 character set to ensure full Unicode support, especially important for international process mining applications with multilingual data.