Java MySQL JDBC Driver class and URL example

Java MySQL Driver FAQ: Can you share a Java/MySQL JDBC Driver and URL example, i.e., how to connect to MySQL in Java?

Sure. Here's a quick post to help anyone that needs a quick MySQL JDBC Driver and URL reference.

The basic MySQL JDBC Driver and Java MySQL URL information you need is shown here:

// MySQL URL (JDBC Connection) String:

// MySQL JDBC Driver String:

MySQL JDBC Driver and URL connection example

If it helps to see the Driver and URL connection strings in a sample application, here's a little Java example that shows how to use the MySQL JDBC Driver and URL to establish a database connection:

public class JdbcMySQLDriverUrlExample
  public static void main(String[] args)
    Connection connection = null;
      // the mysql driver string
      // the mysql url
      String url = "jdbc:mysql://THE_HOST/THE_DATABASE";
      // get the mysql database connection
      connection = DriverManager.getConnection(url,"THE_USER", "THE_PASSWORD");
      // now do whatever you want to do with the connection
      // ...
    catch (ClassNotFoundException e)
    catch (SQLException e)

If you need to use MySQL with Java, I hope this example has been helpful.

Add new comment

Anonymous format

  • Allowed HTML tags: <em> <strong> <cite> <code> <ul type> <ol start type> <li> <pre>
  • Lines and paragraphs break automatically.