Create and configure a JDBC connection so DBeaver can query your MariaDB database.
Connecting lets you run SQL, inspect schemas, and export data from a desktop IDE instead of the CLI. You gain autocomplete, ER diagrams, and result-set editing.
Install DBeaver 23+ and ensure the MariaDB server is reachable, with a user that has SELECT privileges on your target database. Keep host, port, database, user, and password handy.
1) Click Database ▸ New Connection.2) Choose MariaDB (or MySQL if MariaDB is missing). 3) If prompted, allow DBeaver to download the MariaDB driver.
4) Fill the Host, Port (default 3306), Database, User, and Password. 5) Click Test Connection; resolve any driver or firewall issues. 6) Press Finish.
The URL follows:jdbc:mariadb://<host>[:<port>]/<database>?user=<user>&password=<password>&useSSL=<true|false>
Optional parameters include serverTimezone
, autoReconnect
, and allowMultiQueries
.DBeaver fills most fields but you can edit the URL in the Edit Driver Settings dialog.
Click Test Connection. DBeaver displays driver load, handshake, and ping results. A green check means success.Otherwise, examine the error stack: authentication failures point to credentials; communication failures point to firewall, host, or port issues.
Open the new connection, create an SQL Editor, and run:SELECT c.name, o.order_date, o.total_amount FROM Customers c JOIN Orders o ON o.customer_id = c.id LIMIT 10;
DBeaver shows results in a grid where you can copy or export to CSV/JSON.
• Use Projects to separate dev and prod connections.
• Enable Auto-commit off for safer DML.
• Store passwords in a secure keychain, not plaintext.
Wrong driver: Selecting MySQL driver can break SSL. Pick MariaDB or update the driver jar.
Invalid timezone: Omit serverTimezone
or set it incorrectly, causing timestamp shifts. Specify the exact IANA timezone.
Yes. In the connection dialog, open Network, enable SSH, and enter bastion details.
Absolutely.In SSL tab, add client key, client cert, and CA cert, or simply enable Require SSL.
.
Yes. Right-click the connection ▸ Edit ▸ General ▸ Export to create a .dbeaver
file your teammates can import.
Create separate driver profiles in Driver Manager and assign them to each connection. DBeaver will load the proper client JAR per connection.
DBeaver uses one session per editor by default. Enable Keep-alive and set Maximum open connections in Driver Settings to mimic pooling and reduce logins.