Create a database in MySQL from Java?

The following is the code to create a database in MySQL from Java. We are creating the database with name, “Customer_Tracker_Database”

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class CreateDatabaseDemo {
   public static void main(String[] args) {
      Connection con=null;
      Statement stmt=null;
      String yourDatabaseName="Customer_Tracker_Database";
      try {
         con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test3?useSSL=false",
         "root","123456");
         stmt = con.createStatement();
         int status = stmt.executeUpdate("CREATE DATABASE "+yourDatabaseName);
         if(status > 0) {
            System.out.println("Database is created successfully !!!");
         }
      }
      catch(Exception e) {
         e.printStackTrace();
      }
   }
}

The following is the output

Database is created successfully !!!

Here is the snapshot of the sample output

Now let us check the database ‘Customer_Tracker_Database’ is created or not.

The query is as follows

mysql> show databases;

The following is the output

Look at the sample output above, the database is created successfully.

George John

Updated on 30-Jul-2019 22:30:25

• Related Questions & Answers
• Retrieving MySQL Database structure information from Java?
• Create a new database with MySQL Workbench?
• Get the last record from a table in MySQL database with Java?
• How can we create a table from an existing MySQL table in the database?
• How to create a database in MongoDB using Java?
• Get a list of Constraints from MySQL Database?
• How to create a database in MySQL using a JDBC API?
• How to create a database on command line in MySQL?
• Connecting to a MySQL database with Java
• Selecting random entry from MySQL Database?
• Can we create a database with a numeric name with MySQL?
• How to select a random record from a MySQL database?
• How to retrieve table names from a database in MySQL?
• Run SQL file in MySQL database from terminal?
• Connect to MySQL database from command line