DBWillow Logo

Connection Settings Reference

Overview

This reference covers all connection settings available in DBWillow for configuring database connections.

Basic Settings

Connection Name

  • Type: Text
  • Required: Yes
  • Description: Friendly name for the connection
  • Example: "Production Database", "Local MySQL"

Host

  • Type: Text
  • Required: Yes
  • Description: Database server address
  • Examples:
    • localhost - Local database
    • 192.168.1.100 - IP address
    • db.example.com - Domain name

Port

  • Type: Number
  • Required: Yes
  • Default: 3306
  • Description: MySQL server port
  • Common values:
    • 3306 - Standard MySQL port
    • 3307 - Alternative port
    • Custom ports for specific setups

Username

  • Type: Text
  • Required: Yes
  • Description: MySQL username
  • Examples: root, admin, app_user

Password

  • Type: Password
  • Required: Yes
  • Description: MySQL password
  • Security: Encrypted and stored securely

Database

  • Type: Text
  • Required: No
  • Description: Default database to connect to
  • Note: Leave empty to connect to all databases

Advanced Settings

Connection Timeout

  • Type: Number (seconds)
  • Default: 30
  • Description: Maximum time to wait for connection
  • Range: 1-300 seconds
  • Use cases:
    • Increase for slow networks
    • Decrease for faster failure detection

Character Set

  • Type: Dropdown
  • Default: utf8mb4
  • Options:
    • utf8mb4 - Full UTF-8 support
    • utf8 - Basic UTF-8
    • latin1 - Western European
    • Custom character sets

SSL Mode

  • Type: Dropdown
  • Default: Preferred
  • Options:
    • Disabled - No SSL (not recommended)
    • Preferred - Use SSL if available
    • Required - SSL must be enabled
    • Verify CA - Verify certificate authority
    • Verify Identity - Verify server identity

SSL Certificate

  • Type: File path
  • Required: Only if SSL Mode requires it
  • Description: Path to SSL certificate file
  • Use cases: Custom SSL configurations

SSH Tunnel Settings

Use SSH Tunnel

  • Type: Checkbox
  • Default: Unchecked
  • Description: Enable SSH tunnel for connection

SSH Host

  • Type: Text
  • Required: If SSH tunnel enabled
  • Description: SSH server address
  • Example: ssh.example.com, 192.168.1.1

SSH Port

  • Type: Number
  • Default: 22
  • Description: SSH server port
  • Common values: 22, 2222, custom ports

SSH Username

  • Type: Text
  • Required: If SSH tunnel enabled
  • Description: SSH username

SSH Authentication

  • Type: Radio button
  • Options:
    • Password
    • Private Key
  • Description: Authentication method

SSH Private Key

  • Type: File path
  • Required: If using private key
  • Description: Path to private key file
  • Formats: RSA, ED25519, etc.

Best Practices

Security

  • Use SSL for all connections
  • Store credentials securely
  • Use SSH tunnels for remote access
  • Limit host access

Performance

  • Set appropriate timeouts
  • Use connection pooling
  • Optimize character sets
  • Monitor connection health

Troubleshooting

Connection Issues

  • Verify all settings
  • Check network connectivity
  • Review firewall rules
  • Test with command line tools

SSL Issues

  • Verify certificate validity
  • Check SSL mode settings
  • Review certificate paths
  • Test SSL connection separately

Next Steps