To connect to the database, you need to use a JDBC url with the following format

jdbc:mysql://[hostname][:port]/[dbname][?param1=value1][&param2=value2].....

This is described in the Driver documentation. Accordingly, the piece of code you must use is:

try {
                Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  } catch (ClassNotFoundException cnfe)
   {
                System.err.println("Error loading driver:"+cnfe);
  }

             Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Authority?user=root&password=fox123");

}

  here hostName=localhost
  dbname=Authority
  user=root
  password=fox123

Java Tips by : Karmegam

Related:

• Interview Questions in Core Java - Part Two
• Java Interview Questions
• Interview Questions in Core Java

Return to : Java Programming Hints and Tips