No suitable driver found for 'jdbc:mysql://localhost:3306/mysql [duplicate]

Question

Using Java, I get this error when attempting to connect to a mysql database:

java.sql.SQLException: No suitable driver found for  jdbc:mysql://localhost:3306/mysql at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at MyTest1.main(MyTest1.java:28) 

I'm using the mysql-connector-java-5.1.18-bin.jar driver. It is in my build path. I have restarted MySQL. I've also logged on from the command line with root and no password and it connected fine. I'm not currently seeing a port 3306 in netstat. Previously I was getting a different error (I didn't change the code). The error was "jdbc mysql Access denied for user 'root'@'localhost password NO"

try {     Class.forName("com.mysql.jdbc.Driver"); }  catch (ClassNotFoundException e) {     // TODO Auto-generated catch block     e.printStackTrace(); }    try {     String url = "jdbc:mysql://localhost:3306/mysql";     Connection con = DriverManager.getConnection(url, "root", ""); } catch (Exception e){     e.printStackTrace(); } 

Answer 1

In this particular case (assuming that the Class#forName() didn't throw an exception; your code is namely continuing with running instead of throwing the exception), this SQLException means that Driver#acceptsURL() has returned false for any of the loaded drivers.

And indeed, your JDBC URL is wrong:

String url = "'jdbc:mysql://localhost:3306/mysql"; 

Remove the singlequote:

String url = "jdbc:mysql://localhost:3306/mysql"; 

See also:

• Mini tutorial on MySQL + JDBC connectivity

Answer 2

You have to set classpath for mysql-connector.jar

In eclipse, use the build path

If you are developing any web app, you have to put mysql-connector to the lib folder of WEB-INF Directory of your web-app