title: unknown database in jdbc
body: <p>I am using JDBC and new to it. but I keep getting this runtime exception:</p>
  
  <pre><code>   connecting to psysical database...
     com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'kholofelodb'
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  at com.mysql.jdbc.Util.getInstance(Util.java:386)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)
  at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)
  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)
  at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336)
  at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
  at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:792)
  at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:47)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
  at java.sql.DriverManager.getConnection(DriverManager.java:579)
  at java.sql.DriverManager.getConnection(DriverManager.java:221)
  at com.psybergate.database.SimbleCode.main(SimbleCode.java:22)
  </code></pre>
  
  <p><em><strong>Here is the gave code</em></strong></p>
  
  <pre><code>try {
              String connectionURL =      "jdbc:mysql://localhost:3306/kholofelodb";
              Class.forName("com.mysql.jdbc.Driver");
  
              System.out.println("connecting to psysical database...");
              Connection conn = DriverManager.getConnection(connectionURL, USER,
                      PASS);
  
              Statement statement = conn.createStatement();
              System.out.println("Connection has been made");
  
              Scanner keyBoardScanner = new Scanner(System.in);
              System.out.println("Enter table name:");
              String tableName = keyBoardScanner.nextLine();
  
              System.out.println("Creating table...");
              statement.executeQuery("create table " + tableName
                      + " (name , age ,salary)");
              System.out.println("Table successfully created");
              System.out.println("Inserting data into the table ...");
              statement.executeUpdate("insert into " + tableName
                      + "values (kholofelo , 21 , 9969696)");
          } 
  </code></pre>
  
  <p>how do I get this code to work? I am only a beginner with JDBC.... </p>
  
  <p>for the above code;
       PASS = "passowrd", USER = "root"</p>
  
  <p>I had a problem with port which it was fixed through this site</p>
  
  <p>thanks a lot</p>