MariaDB JDBC Driver Download

Download the MariaDb JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the MariaDb JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to MariaDb. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each MariaDb driver uses its own syntax — see the connection details below.

The MariaDb JDBC driver

MariaDB is a community-developed, drop-in replacement for MySQL, created by MySQL's original developers after Oracle's acquisition. It adds features like Galera clustering, ColumnStore storage engine, and more advanced replication options while maintaining full MySQL compatibility.

The MariaDB JDBC URL

• Required File(s): mysql-connector-java-nn-bin.jar
• Java Driver Class: com.mysql.jdbc.Driver
• JDBC URL: jdbc:mysql://HOST[:PORT][/DB]
• Website: MySQL

Download MariaDb JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

Enable Remote Access on MariaDB Server

A remote client is stopped by two independent settings: the address the server binds to, and the host a database account is allowed to log in from.

1. Check where the server listens. MariaDB itself binds every address, but Debian and Ubuntu packages ship bind-address = 127.0.0.1, which accepts loopback connections only. Remove that directive to bind everything, or point it at the address clients use — MariaDB takes a single bind address. Where the older skip-networking directive is still present, TCP/IP is switched off entirely and no port setting will help; delete it. Restart the service afterwards.
2. Grant the user access from your host. An account is a user and a host together, so bar@'localhost' does not cover a connection from your desk. On the server run mariadb -u root -p and grant explicitly:
   GRANT ALL ON foo.* TO bar@'202.54.10.20' IDENTIFIED BY 'PASSWORD';
   Replace the database, the user and the IP address of the machine running DbSchema. SELECT user, host FROM mysql.user; shows what exists today.
3. Open port 3306 in the server's firewall. The database listens on port 3306 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
4. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

An Access denied message means the server answered and rejected the account; a timeout means the traffic never got there, which points at the bind address or the firewall.

• Or reach the server through SSH. When the database port is deliberately closed to the internet, press Setup SSH Tunnel... in the Connection Dialog and connect through a host that is exposed. The database host and port are then the ones seen from the SSH host — often localhost. See the SSH tunnel guide.

MariaDB Installation Tips

Install MariaDb from http://www.mysql.com. During installation go for a detailed install, and when you are prompted for the user password check the 'Enable root access from remote machines'.

Enabling this you will be allowed to connect to MariaDb from another computer. Remember the password you set here, it will be requested when connecting to the database as user root.

DbSchema and MariaDB

Because MariaDB is wire-compatible with MySQL, DbSchema connects using the MySQL JDBC driver and renders all InnoDB tables, foreign keys, and indexes in the ER diagram. Use Schema Synchronization to generate MariaDB-specific DDL including COLLATION and ENGINE clauses.