How to connect to mysql through jdbc

Question

I'm trying to establish a connection to my mySQL database through a jdbc connection. I'm using a localhost connection at port 3006.

try{
   Connection myConn = DriverManager.getConnection("JDBC:mysql://localhost:3306/cupcakes", "kristoffer", "******");
   Statement myStmt = myConn.createStatement();

   ResultSet myRs = myStmt.executeQuery("Select * from cupcakes");
   while(myRs.next()){
       System.out.println("Cupcakes: " + myRs.getString("name"));

i get this error: java.sql.SQLException: No suitable driver found for JDBC:mysql://localhost:3306/cupcakes at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at driverappformysql.DriverAppforMYSQL.main(DriverAppforMYSQL.java:21)

How can i assure that i'm connecting to the correct database, and how can i get the right url?

Possible duplicate of [No suitable driver found for 'jdbc:mysql://localhost:3306/mysql](https://stackoverflow.com/questions/8146793/no-suitable-driver-found-for-jdbcmysql-localhost3306-mysql) or https://stackoverflow.com/questions/1911253/the-infamous-java-sql-sqlexception-no-suitable-driver-found — Lukasz Szozda, Feb 25 '18 at 16:24
Try lowercase: `jdbc:mysql://localhost:3306/cupcakes`. I've never seen it using uppercase `JDBC:` prefix, and it's likely case-sensitive. — Andreas, Feb 25 '18 at 16:47

Sodium · Accepted Answer · 2020-04-02T19:02:00.867

2

Specify driver class..add this line before opening connection to database

Class.forName("com.mysql.jdbc.Driver");

Try this

try{
   Class.forName("com.mysql.jdbc.Driver");
   Connection myConn = DriverManager.getConnection("JDBC:mysql://localhost:3306/cupcakes", "kristoffer", "******");
   Statement myStmt = myConn.createStatement();

   ResultSet myRs = myStmt.executeQuery("Select * from cupcakes");
   while(myRs.next()){
       System.out.println("Cupcakes: " + myRs.getString("name"));

Further after successful connection..execute this query to get selected database

SELECT DATABASE() FROM DUAL;

edited Apr 02 '20 at 19:02

answered Feb 25 '18 at 16:28

Sodium

1,016
1
9
22

1

I get a class not found exception, shall i create a new class? – Kristoffer Tølbøll Feb 25 '18 at 16:31
Include mysql connector jar to your project, I mean to say the database driver jar – Sodium Feb 25 '18 at 16:33
I can only find .zip or .tar files on the mysql website? – Kristoffer Tølbøll Feb 25 '18 at 16:35
Correct...extract zip file this includes jar...download from here https://dev.mysql.com/downloads/connector/j/ – Sodium Feb 25 '18 at 16:36
Thank you. I added the jar file under libraries, however i still get a ClassNotFoundException? – Kristoffer Tølbøll Feb 25 '18 at 16:46
Kindly paste complete code snippet..which is a part of connection i.e. try catch block – Sodium Feb 25 '18 at 16:48
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/165783/discussion-between-gaurav-genius-and-kristoffer-tolboll). – Sodium Feb 25 '18 at 16:51

score 0 · Answer 2 · answered Feb 25 '18 at 17:13

0

Add

Class.forName("com.mysql.jdbc.Driver");

Before opening connection.

Make sure you have added MySql to jdbc connector jar file which you can download on mysql's website.

answered Feb 25 '18 at 17:13

pritam parab

85
2
10

Using `Class.forName` hasn't been necessary in a simple application like the one of the OP for at least a decade. – Mark Rotteveel Feb 26 '18 at 09:14

How to connect to mysql through jdbc

2 Answers2