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
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.
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.
Try the MariaDb JDBC Driver using DbSchema
DbSchema is a desktop application which can connect to MariaDb using JDBC drivers.- 1 Download DbSchema. DbSchema has a Free Community Edition and a PRO Edition No email or registration is required.
- 2
Choose to connect to the database, and choose MariaDb.
- 3
At this point, DbSchema already downloads the JDBC driver into this folders:
- C:\Users\YourUser\.DbSchema\drivers\MariaDb (Windows) or
- /Users/YourUser/.DbSchema/drivers/MariaDb (Linux and MacOS).
In the Connection Dialog, choose the driver and a JDBC URL template. Some databases have multiple connection options, so you might see several templates. Select whether the database is on your computer or a different one. If it’s on another machine, find the host name. Read our documentation to find the Host Name.
- 4 Press the Ping button to test the connectivity.
- 5
In the URL dropdown, there is an option to 'Manually Edit the URL', which allows customization and cloud connections.
Select this option to view and modify the generated JDBC URL.
- 6
After connecting, DbSchema will reverse-engineer the database and create the initial diagrams.
Double-click any table header or column to edit.
- 7
DbSchema integrates multiple themes so you can personalize your interface. I will present the next features in the Dark Theme.
- 8
Build SQL Queries visually without having to write any line of code. Add and edit tables with a simple click.
- 9
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.
- 10
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.
- 11
DbSchema can execute Groovy or Java Scripts with direct access to the DbSchema API.
This will help to solve different tasks without visual interaction.
- 12
Discover the SQL Editor from the menu to edit and execute queries.
For a detailed list of features, please read this Documentation