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.

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) 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:

fyicenter> javac 
   MySqlJdbcUrl.java

fyicenter> java -cp .;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.

⇒ MySqlCreateDatabase.java - Connector/J JDBC Create Database

⇐ MySqlJdbcConnection.java - Connector/J JDBC Connection

⇑ Examples for Connector/J - JDBC Driver for MySQL

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