Connecting to a MySQL Database with Java

Question

I want to connect to my MySQL database with Java.

I am using JDBC and I have the driver installed. (com.mysql.jdbc.Driver)

The only problem is that I keep getting an error:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException The last packet sent successfully to the server was 0 milliseconds ago.

Here is my code:

Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql:/mydomain.com/mydatabase", "username", "password");

I am not positive how to compose the URL (and where I get my username and password) but I have done A LOT of research.

I am the only person with acess to my database and domain, so there's no use asking the admin.

I use phpMyAdmin to create the database(s) and manage them. Do I use my phpMyAdmin username and password or what?

By the way, my site is hosted on Yahoo! Small Business.

So my questions are:

How do I make the connection URL?
What is my username and password?

it's not duplicate, he added his error, and its not one i've seen before — Bart Hofma
– Bart Hofma, Commented Dec 8, 2014 at 16:00

Roshnal · Accepted Answer · 2011-09-05 05:14:13Z

1

I would say you are missing a forward slash on your URL.

Connection connection = DriverManager.getConnection("jdbc:mysql://mydomain.com/mydatabase", "username", "password");

Or I have a feeling that there is something wrong with your access privileges. This same thing happened to me also and it was a problem of Firewall blocking the port on the server. So verify this is not the case.

answered Sep 5, 2011 at 5:14

Roshnal

1,3143 gold badges17 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

speedRS · Accepted Answer · 2011-09-05 00:14:05Z

0

How do I make the connection URL?

Are you missing a forward slash in your URL? I would've assumed it would be something like:

jdbc:mysql://server/database

answered Sep 5, 2011 at 0:14

speedRS

1,2402 gold badges11 silver badges17 bronze badges

Comments

Bart Hofma · Accepted Answer · 2014-12-08 17:13:10Z

0

Load the drivers for mysql
 Class.forName("com.mysql.jdbc.Driver");
connect with the data base
 con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/widget_corp","dbuser","dbpassword");               
.....jdbc:mysql://this is use as it is
.....127.0.0.1 this is the address of localhost You can use the word "localhost" insted of      "127.0.0.1"
.....dbuser is the data base user
.....dbpassword is the password of the dbuser
.....3306 is the default port used for database

edited Dec 8, 2014 at 17:13

Bart Hofma

6445 silver badges19 bronze badges

answered Oct 9, 2014 at 12:46

NomanJaved

1,41020 silver badges39 bronze badges

Collectives™ on Stack Overflow

Connecting to a MySQL Database with Java

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related