How to Create a MySql Database using JDBC

Question

Can we create a new MySQL database( not a table, I want a new database) from java code ? I have searched the internet and I get code only for connecting with existing mysql databases. Can i create a new database at run time using java code.

please help

Note that not all JDBC drivers supports all DDL statements and that it's generally considered bad practice to create db's and tables using JDBC, unless you'd like to (re)invent a DB manager tool in Java. For normal apps creating the datamodel ought to be a separate task. — BalusC
– BalusC, Commented Mar 6, 2010 at 11:58

Dhinakar · Accepted Answer · 2012-12-28 13:52:29Z

6

In your connection string omit a database name and then execute Create database command.

Connection String: jdbc:mysql://localhost

Create Database Syntax : stm.executeUpdate("CREATE DATABASE dbname")

edited Dec 28, 2012 at 13:52

Dhinakar

4,1267 gold badges39 silver badges69 bronze badges

answered Mar 6, 2010 at 9:53

Bozho

599k147 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

LPL · Accepted Answer · 2011-12-22 00:23:25Z

-1

Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1";
Connection conn = DriverManager.getConnection(url);

edited Dec 22, 2011 at 0:23

LPL

17.1k6 gold badges54 silver badges98 bronze badges

answered Mar 6, 2010 at 13:14

user287728

1

1 Comment

BalusC Over a year ago

Uhm, I think you didn't understood the question nor the already accepted answer :)

Collectives™ on Stack Overflow

How to Create a MySql Database using JDBC

2 Answers 2

Comments

1 Comment

Your Answer

Collectives™ on Stack Overflow

How to Create a MySql Database using JDBC

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related