v3.4.0 StableLocal-First Native MySQL Client

Connection Troubleshooting & Diagnostic FAQ | VloamDb Docs

Comprehensive diagnostic solutions for MySQL network timeouts, authentication plugin mismatches, and SSH tunnel permission issues.

macOS Gatekeeper Reports App is Damaged

On modern macOS (Sonoma / Sequoia), Apple Gatekeeper applies an extended quarantine attribute to DMG downloads from outside the Mac App Store, occasionally reporting that the app is "damaged".

🛠️
Solution: Clear Quarantine Flag

Open Terminal and execute the following command:

Terminal
sudo xattr -rd com.apple.quarantine /Applications/VloamDb.app

Press Enter, enter your Mac password, and launch VloamDb normally.

MySQL 8.0 Authentication Plugin Error

When connecting to MySQL 8.0+ instances over unencrypted transports, older clients fail with <code>caching_sha2_password cannot be loaded</code>.

VloamDb natively supports both <code>caching_sha2_password</code> and legacy <code>mysql_native_password</code>. If connection fails:

  • Ensure "Allow Public Key Retrieval" is checked in advanced options;
  • Verify that cloud RDS security group rules permit your public IP.

SSH Tunnel Timeout & Private Key Issues

When connecting through a bastion jump host, if SSH handshakes time out:

1. Private Key Format

Ensure key is in standard OpenSSH PEM/PKCS8 format. Convert PuTTY .ppk keys via PuTTYgen first.

2. File Permissions

On macOS, ensure strict 600 permissions (`chmod 600 ~/.ssh/id_rsa`) or SSH will reject the key.