How to Create a MySql Database using JDBC

Question

Hi,

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

Answer 1

In your connection string omit a database name. i.e. jdbc:mysql://localhost and then execute stm.executeUdate("CREATE DATABASE dbname")

Answer 2

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