MySqlJdbcUrl.java - Connector/J JDBC Connection URL

Q

How to use port number and database name in the connection URL string for MySQL database using the Connector/J JDBC driver? I want to see a Java program example.

✍: FYIcenter.com

A

Here is a Java example that shows you how to specify port number, database name, and instance name in the connection URL string for MySQL database using the Connector/J JDBC driver:

// Copyright (c) 2016 FYIcenter.com
import java.sql.DriverManager;
import java.sql.Connection;

// Example of Connector/J  JDBC connection URL for MySQL server
public class MySqlJdbcUrl {
   public static void main(String [] args) throws Exception {

      // Connector/J JDBC connection URL with required elements
      String url = "jdbc:mysql://localhost?user=root&password=fyicenter&useSSL=false";
      Connection con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      con.close();

      // Connector/J JDBC connection URL with port number
      url = "jdbc:mysql://localhost:3306?user=root&password=fyicenter&useSSL=false";
      con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      con.close();

      // Connector/J JDBC connection URL with database (catalog) name
      url = "jdbc:mysql://localhost/mysql?user=root&password=fyicenter&useSSL=false";
      con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      con.close();
   }
}

You can compile and run the above example in a command window as shown below:

C:\fyicenter>\local\jdk-1.8.0\bin\javac 
   MySqlJdbcUrl.java

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\mysql-connector-java-5.1.40\mysql-connector-java-5.1.40-bin.jar 
   MySqlJdbcUrl

JDBC connection URL: 
   jdbc:mysql://localhost?user=root&password=fyicenter&useSSL=false
   Connected to:
   
JDBC connection URL: 
   jdbc:mysql://localhost:3306?user=root&password=fyicenter&useSSL=false
   Connected to:
   
JDBC connection URL: 
   jdbc:mysql://localhost/mysql?user=root&password=fyicenter&useSSL=false
   Connected to: mysql

Note that MySQL server does not provide a default database. You need to specify the database name as the path name in the connection URL.

 

Examples for Connector/J - JDBC Driver for MySQL

⇒⇒FAQ for Connector/J - JDBC Driver for MySQL

2016-12-02, 1439👍, 0💬