Connecting to a MySQL database with Java

Use below URL to connect MySQL database. The syntax is as follows −

String MySQLURL="jdbc:mysql://localhost:3306/yourDatabaseName?useSSL=false";
String databseUserName="yourUserName";
String databasePassword="yourPassword";

Example

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class ConnectToDatabase {
   public static void main(String[] args) {
      String MySQLURL = "jdbc:mysql://localhost:3306/web?useSSL=false";
      String databseUserName = "root";
      String databasePassword = "123456";
      Connection con = null;
      try {
         con = DriverManager.getConnection(MySQLURL, databseUserName, databasePassword);
         if (con != null) {
            System.out.println("Database connection is successful !!!!");
         }
      } catch (Exception e) {
         e.printStackTrace();
      }
   }
}

Output

Database connection is successful !!!!

Here is the snapshot of the output −

AmitDiwan

Published on 12-Dec-2019 06:33:01

• Related Questions & Answers
• Connecting to MySQL database from the command line?
• After connecting to MySQL server how can we select a database from command prompt?
• While connecting to one MySQL database, how can I see the list of tables of other MySQL database?
• How to delete data in a MySQL database with Java?
• How to update data in a MySQL database with Java?
• How to insert data into a MySQL database with Java?
• Connecting MongoDB with NodeJS
• Create a new database with MySQL Workbench?
• Create a database in MySQL from Java?
• Resolve Unknown database in JDBC error with Java-MySQL?
• Connecting to and Disconnecting from the MySQL Server
• Command Options for Connecting to the MySQL Server
• Connecting to the MySQL Server Using Command Options
• Get the last record from a table in MySQL database with Java?
• Java application to insert null value into a MySQL database?