Download MySql 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 MySql 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 the MySql JDBC Driver

The driver library files are compressed in a zip archive.

If you cannot connect, or you get issues with the driver, please ask DbSchema Team for help.

Solving Common Connectivity Issues

Enable Remote Access on MySql Server

By default MySql 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 mysql -u root -p <root_password> The mysql 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.

MySql Installation Tips

Configure MySql to allow remote connections Install MySql 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 MySql from another computer. Remember the password you set here, it will be requested when connecting to the database as user root.

Try the MySql JDBC Driver using DbSchema

DbSchema is a desktop application which can connect to MySql using JDBC drivers.
  1. 1 Download DbSchema. DbSchema has a Free Community Edition and a PRO Edition No email or registration is required.
  2. 2 Choose to connect to the database, and choose MySql. Connect to database
  3. 3 Connection-dialog

    At this point, DbSchema already downloads the JDBC driver into this folders:

    • C:\Users\YourUser\.DbSchema\drivers\MySql (Windows) or
    • /Users/YourUser/.DbSchema/drivers/MySql (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. 4 Press the Ping button to test the connectivity.
  5. 5 Edit JDBC URL 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. 6 DbSchema Diagrams After connecting, DbSchema will reverse-engineer the database and create the initial diagrams. Double-click any table header or column to edit.
  7. 7 DbSchema Dark Theme DbSchema integrates multiple themes so you can personalize your interface. I will present the next features in the Dark Theme.
  8. 8 Visual Query Builder Build SQL Queries visually without having to write any line of code. Add and edit tables with a simple click.
  9. 9 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.
  10. 10 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.
  11. 11 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.
  12. 12 SQL Editor Discover the SQL Editor from the menu to edit and execute queries. For a detailed list of features, please read this Documentation