Create a stable MariaDB JDBC data source in JetBrains DataGrip with the correct driver, URL, credentials, and optional SSL.
Install DataGrip 2023.3+ and ensure the MariaDB (or MySQL) JDBC driver is downloaded. Collect the database host, port (3306), user, password, and default schema.
Open File → Data Sources & Drivers, click Drivers, select MariaDB, and press Download. DataGrip stores the JAR under ~/.DataGrip*/jdbc-drivers/
.
Inside Data Sources & Drivers click + → MariaDB. Enter host, port, user, password, and database.Enable Save password to avoid re-prompting.
The JDBC URL appears as jdbc:mariadb://db.acme.com:3306/shop?serverTimezone=UTC
. Add optional parameters like allowMultiQueries=true
or useSSL=true
when security is required.
Click Test Connection. DataGrip pings the server and loads metadata. Green status means success. Press Apply → OK to store the data source for future sessions.
Run SELECT id, name, email FROM Customers ORDER BY created_at DESC LIMIT 10;
.If rows return, privileges are correct.
In the data-source dialog, open the SSH/SSL tab. Add an SSH key or check Use SSL and supply the CA, client cert, and key. DataGrip appends the right flags to the JDBC URL.
Always set serverTimezone
to avoid time drift, store secrets in DataGrip’s password vault, and share data-source settings via .idea files for team consistency.
.
It usually works, but the official MariaDB driver offers better compatibility and supports MariaDB-specific SQL modes.
Yes. Check Share data source in the dialog. DataGrip stores the settings in .idea/dataSources/
so the whole team can reuse them.
Open the SSH/SSL tab, enable Use SSH tunnel, and enter bastion credentials. DataGrip forwards traffic automatically.