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

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

Can you post the mysql command line that you are using? It may be just a case where one is using "localhost" and the other 127.0.0.1. — hafichuk, Nov 16 '11 at 04:41
few points in this link on not importing anything ... http://dev.mysql.com/doc/refman/5.1/en/connector-j-usagenotes-basic.html#connector-j-usagenotes-connect-drivermanager — r0ast3d, Nov 16 '11 at 04:42
It doesn't matter if it's on your build path when you're running it--is it on your run-time classpath? — Dave Newton, Nov 16 '11 at 05:11
Are you sure you have mysql-connector-java-5.1.18-bin.jar on classpath? — Igor Nikolaev, Nov 16 '11 at 05:12
I'm using Eclipse so when I added the library, it should have added it to the classpath. The jar is under refernced libraries. I updated the command above. The error is on the "Connection" line — user994165, Nov 16 '11 at 06:10

score 50 · Accepted Answer · edited Mar 11 '18 at 08:19

50

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

2

The mysql-connector should be provided by the system and not be included in a jar or war. – Marcel Korpel Jul 15 '15 at 20:15
to eliminate one possible source of error, you can from a command prompt, "CLASSPATH=%CLASSPATH%;mysql-connector.jar; – DoesEatOats Jul 19 '18 at 16:48
Build path is important, save some time for your life. – Jackson Jan 13 '22 at 12:30

score 10 · Answer 3 · answered Dec 17 '12 at 23:00

When using Netbean, go under project tab and click the dropdown button there to select Libraries folder. Right Click on d Library folder and select 'Add JAR/Folder'. Locate the mysql-connectore-java.*.jar file where u have it on ur system. This worked for me and I hope it does for u too. Revert if u encounter any problem

score 5 · Answer 4 · edited Mar 30 '14 at 07:52

5

A typographical error in the string describing the database driver can also produce the error.

A string specified as:

"jdbc:mysql//localhost:3307/dbname,"usrname","password"

can result in a "no suitable driver found" error. The colon following "mysql" is missing in this example.

The correct driver string would be:

jdbc:mysql://localhost:3307/dbname,"usrname","password"

edited Mar 30 '14 at 07:52

MarsAtomic

10,436
5
35
56

answered Mar 30 '14 at 07:30

Karthick

51
1
2

Great! I had the exact same symptoms as the OP, and you guessed exactly the mistake I made: after adding port number at the wrong place **jdbc:mysql:3306//localhost** I deleted it together with the column: **jdbc:mysql//localhost** and became extremely puzzled, where did my `com.mysql.jdbc.Driver` go? – MKaama Oct 05 '14 at 09:50
Thanks so much! I was missing a ':' in my jdbc string and sure enough ran into this issue. :-) – Joseph Bleau Nov 10 '15 at 18:51

score 4 · Answer 5 · edited Dec 27 '13 at 21:36

This error happened to me, generally it'll be a problem due to not including the mysql-connector.jar in your eclipse project (or your IDE).

In my case, it was because of a problem on the OS.

I was editing a table in phpmyadmin, and mysql hung, I restarted Ubuntu. I cleaned the project without being successful. This morning, when I've tried the web server, it work perfectly the first time.

At the first reboot, the OS recognized that there was a problem, and after the second one, it was fixed. I hope this will save some time to somebody that "could" have this problem!

score 1 · Answer 6 · answered Feb 09 '14 at 02:59

i had same problem i fix this using if developing jsp, put mysql connetor into WEB-INF->lib folder after puting that in eclipse right click and go build-path -> configure build patha in library tab add external jar file give location where lib folder is

score 0 · Answer 7 · answered Feb 12 '15 at 20:25

Just telling my resolution: in my case, the libraries and projects weren't being added automatically to the classpath (i don't know why), even clicking at the "add to build path" option. So I went on run -> run configurations -> classpath and added everything I needed through there.

score 0 · Answer 8 · answered Jun 24 '15 at 08:56

( If your url is correct and still get that error messege ) Do following steps to setup the Classpath in netbeans,

Create a new folder in your project workspace and add the downloaded .jar file(eg:- mysql-connector-java-5.1.35-bin.jar )
Right click your project > properties > Libraries > ADD jar/Folder Select the jar file in that folder you just make. And click OK.

Now you will see that .jar file will be included under the libraries. Now you will not need to use the line, Class.forName("com.mysql.jdbc.Driver"); also.

If above method did not work, check the mysql-connector version (eg:- 5.1.35) and try a newer or a suitable version for you.

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

8 Answers8

See also:

Linked

Related