How to Connect MySQL to DBeaver in PostgreSQL

How do I connect MySQL to DBeaver?

Create a new MySQL connection in DBeaver, supply host, port, database, user credentials, test, and save.

Welcome to the Galaxy, Guardian!

Oops! Something went wrong while submitting the form.

Description

Why connect MySQL to DBeaver?

DBeaver offers an IDE-style UI, visual query plan, and data editing that speeds up MySQL development, debugging, and reporting.

What prerequisites are needed?

Install DBeaver 23+, ensure MySQL server is reachable, and have a user with SELECT on the target schema. Optional: SSH or SSL keys.

How do I add a new MySQL connection in DBeaver?

Click Database ▶ New Database Connection.
Select MySQL; DBeaver downloads the JDBC driver automatically.
Fill Host, Port (3306), Database, User, and Password.
Optional: open Driver Properties to set useSSL, serverTimezone, or allowPublicKeyRetrieval.
Click Test Connection; when green, press Finish.

How do I tunnel through SSH?

In the Connection Settings ▶ SSH tab, toggle Use SSH Tunnel, enter bastion host, port 22, username, and key file or password, then retest.

How can I run a quick query to verify?

Open the connection, create a new SQL Editor, and run SELECT COUNT(*) FROM Customers;. Results grid confirms access.

Which driver parameters matter most?

useSSL enforces encryption, serverTimezone avoids DST errors, allowPublicKeyRetrieval=true resolves MySQL 8 auth when SSL disabled.

Best practices for production connections?

Create a read-only MySQL user, store passwords in DBeaver’s secure storage, and enable Auto Commit off to avoid accidental writes.

What are common mistakes?

Driver not downloaded or wrong host/port. Fix by reopening Edit Connection, verifying network, and clicking Download beside driver.

Timezone mismatch causing Cannot load driver class. Add serverTimezone=UTC in the URL.

Why How to Connect MySQL to DBeaver in PostgreSQL is important

How to Connect MySQL to DBeaver in PostgreSQL Example Usage


-- Find top-10 customers by lifetime spend
SELECT   c.id,
         c.name,
         SUM(o.total_amount) AS lifetime_value
FROM     Customers c
JOIN     Orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY lifetime_value DESC
LIMIT    10;

How to Connect MySQL to DBeaver in PostgreSQL Syntax


jdbc:mysql://<host>:<port>/<database>?user=<user>&password=<password>&useSSL=<true|false>&serverTimezone=<tz>&allowPublicKeyRetrieval=<true|false>

# Example
jdbc:mysql://db.prod.internal:3306/shop?user=reporter&password=***&useSSL=true&serverTimezone=UTC&allowPublicKeyRetrieval=true

Common Mistakes

Skipping driver download: Users click Finish before the JDBC driver finishes downloading, resulting in "Driver class not found." Always wait for the progress bar or manually click Download.
Leaving useSSL undefined: MySQL 8 defaults to SSL; leaving the flag blank can block login. Explicitly set useSSL=true (with cert) or false (dev) in Driver Properties.