Download MariaDb JDBC Driver

What are JDBC Drivers?

JDBC drivers are Java library files with the extension '.jar', used by Java applications to connect to the database. Usually they are provided by the same company which developed the database software.

What is the JDBC URL?

The JDBC Driver requires the JDBC URL to know where the database is located ( on which machine and port), the database name or other settings. All this are passed as a string, specific for each database and driver.

Download the MariaDb JDBC Driver

  • 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 files are compressed in a zip file.

for any issues with the driver, you can write to us.

Enable Remote Access on MariaDb Server

By default MariaDb does not allow connecting from another machine as the one where the server is installed. You can enable remote access during installation ( see the next chapter ) or later using the instructions below.
  • On the server type in the command prompt or terminal mariadb -u root -p <root_password> The mariadb console should start.
  • List the databases using show databases
  • View the configured grants using select * from db;
  • Enable remote access for a user foo using GRANT ALL ON foo.* TO bar@'202.54.10.20' IDENTIFIED BY 'PASSWORD'; Here you have to edit the user ( put your user instead of foo ), the IP of the client machine and the root password.
If this didn't help, please try to search the web for tutorials.

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'.

Configure MariaDb to allow remote connections

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 Database Designer

Design MariaDb Databases using DbSchema

Downloaded the JDBC driver? Now visually design, explore, and manage your MariaDb database with ease using DbSchema's Free Community Edition or PRO Edition. No coding required!

Connection-dialog

  1. 1 Connection-dialog

    Design MariaDb using interactive diagrams. The diagrams will be saved to the design model file and can be later reopen.

  1. 2 Visual Query Builder Build SQL Queries visually without having to write any line of code. Add and edit tables with a simple click.
  2. 3 Relational Data Editor The Relational Data Editor can visually explore data from multiple tables. You can cascade into further tables via foreign keys or virtual foreign keys. There is no limit to how many tables can be opened at once.
  3. 4 Schema Synchronization DbSchema model contains its own image of the schema, independent from the database. Connecting to another database won't change the model schema unless you choose to refresh it from the database.
  4. 5 Automation Scripts DbSchema can execute Groovy or Java Scripts with direct access to the DbSchema API. This will help to solve different tasks without visual interaction.
  5. 6 SQL Editor Discover the SQL Editor from the menu to edit and execute queries. For a detailed list of features, please read this Documentation

For complete information on features and licensing, visit our PRO Edition page.