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 JDBC MySQL Driver post to help anyone that needs a quick MySQL JDBC Driver and URL reference when using MySQL with Java.

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

MySQL URL (JDBC Connection) String:
jdbc:mysql://HOST/DATABASE

MySQL JDBC Driver String:
com.mysql.jdbc.Driver

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 simple Java MySQL 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;
    try
    {
      // the mysql driver string
      Class.forName("org.mysql.Driver");
    
      // 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)
    {
      e.printStackTrace();
      System.exit(1);
    }
    catch (SQLException e)
    {
      e.printStackTrace();
      System.exit(2);
    }
  }
}

I hope this simple MySQL JDBC Driver and Java MySQL URL reference helps. There are also many other Java, JDBC, and MySQL tutorials on this site. Just use our search form to find many other examples.