MySQL

MySQL Database Connection

MySQL is one of the most popular relational databases. Datablast connects to MySQL servers using standard connection parameters. This guide covers how to gather and configure the required credentials.

---

1. Required Connection Information

Essential Parameters

Parameter	Description	Default
Host	MySQL server address (localhost, IP, or domain name)	localhost
Port	MySQL server port number	3306
Schema	Database name you want to connect to	-
User	MySQL username with appropriate permissions	-
Password	Password for the MySQL user	-

Connection String Format

mysql://user:password@host:port/schema

---

2. Gathering MySQL Credentials

From Your Database Administrator

Contact your DBA for:

• Server hostname or IP address
• Database name (schema)
• Username and password
• Port number (if different from 3306)
• SSL requirements

From Cloud Providers

PlanetScale:

• Connection strings available in dashboard
• Uses SSL/TLS by default
• Provides branch-specific credentials

Azure Database for MySQL:

• Server name: servername.mysql.database.azure.com
• Username format: username@servername
• SSL connection required

AWS RDS MySQL:

• Endpoint available in RDS console
• Standard MySQL authentication
• Security group configuration required

Google Cloud SQL:

• Instance connection name format
• Public IP or private IP options
• Cloud SQL Proxy available for secure connections

---

3. Testing Connection via Command Line

Basic Connection Command

mysql --host=HOST --port=PORT --user=USER --password --database=SCHEMA

Short Form Options

mysql -h HOST -P PORT -u USER -p SCHEMA

Examples

Local MySQL:

mysql -h localhost -P 3306 -u myuser -p mydatabase

Remote MySQL:

mysql -h db.example.com -P 3306 -u appuser -p production_db

With SSL:

mysql -h secure-db.com -P 3306 -u user -p --ssl-mode=REQUIRED database

💡 Security Tip: Use -p without the password to enter it securely when prompted. Never include passwords in command history.

---

4. Configure Datablast Connection

Connection Form Fields

Field	Example Value	Notes
Connection Name	Production MySQL	Friendly name for the UI
Host	db.mycompany.com	Server address or IP
Port	3306	Usually 3306 for MySQL
Schema	analytics_db	Database name
User	datablast_user	MySQL username
Password	••••••••••••	User password (hidden)
Description	Main analytics database	Optional connection notes

Advanced Options

SSL Configuration:

• Enable if your MySQL server requires encrypted connections
• Common for cloud-hosted databases

Connection Pool:

• Configure max connections if needed
• Useful for high-traffic applications

---

5. Security Best Practices

User Permissions

Create a dedicated MySQL user for Datablast:

-- Create user
CREATE USER 'datablast'@'%' IDENTIFIED BY 'secure_password';

-- Grant necessary permissions
GRANT SELECT ON analytics_db.* TO 'datablast'@'%';

-- For specific tables only
GRANT SELECT ON analytics_db.users TO 'datablast'@'%';
GRANT SELECT ON analytics_db.orders TO 'datablast'@'%';

-- Apply changes
FLUSH PRIVILEGES;

Connection Security

• Use SSL/TLS: Enable encrypted connections for remote databases
• Limit Host Access: Restrict user to specific IP addresses
• Minimal Permissions: Grant only SELECT permissions unless write access is needed
• Strong Passwords: Use complex passwords or certificate-based authentication

Firewall Configuration

Ensure your MySQL server allows connections from Datablast:

• Add Datablast IP to allowlist
• Configure security groups (AWS/Azure)
• Update iptables rules if applicable

---

6. Configuration File Alternative

Using MySQL Option Files

Instead of entering credentials each time, create a configuration file:

Linux/macOS (~/.my.cnf):

[client]
host=db.example.com
port=3306
user=datablast_user
password=your_password
database=analytics_db

Windows (C:\Users\username\.my.cnf):

[client]
host=db.example.com
port=3306
user=datablast_user
password=your_password
database=analytics_db

⚠️ Security: Protect configuration files with proper file permissions (chmod 600 on Unix systems).

---

7. Troubleshooting

Connection Refused

• Check if MySQL is running: systemctl status mysql
• Verify port: netstat -tlnp | grep 3306
• Test network connectivity: telnet host 3306

Access Denied

• Verify credentials: Double-check username and password
• Check user permissions: Ensure user has database access
• Host restrictions: Confirm user can connect from your IP

SSL/TLS Issues

• SSL requirement: Some servers require SSL connections
• Certificate validation: May need to disable strict SSL verification
• Protocol versions: Ensure compatible TLS versions

Performance Issues

• Connection pooling: Implement connection limits
• Query optimization: Use EXPLAIN to analyze slow queries
• Index usage: Ensure proper indexing on queried tables

---

8. Common Cloud Provider Settings

Amazon RDS

Host: mydb.cluster-xyz.us-east-1.rds.amazonaws.com
Port: 3306
SSL: Required

Google Cloud SQL

Host: 1.2.3.4 (Public IP)
Port: 3306
SSL: Recommended

Azure Database for MySQL

Host: myserver.mysql.database.azure.com
Port: 3306
User: username@myserver
SSL: Required

---

Useful Links

• MySQL Official Connection Guide
• MySQL Connection Options
• MySQL SSL/TLS Configuration

Always use encrypted connections for production databases and follow the principle of least privilege when creating database users.