How to specify path to mySQL using localhost?

Question

I have been having issues specifying the path (I have two files: comments.frm and db.opt in the following folder: C:\xampp\mysql\data\feedback)... I am using XAMPP and mySQL. I am not sure why I am having an error? Please, take a look this part of my code:

public void readDataBase() throws Exception {
   try {
        // This will load the MySQL driver, each DB has its own driver
      Class.forName("com.mysql.jdbc.Driver");
      // Setup the connection with the DB
    connect = DriverManager
         .getConnection("jdbc:mysql://localhost//feedback"
              + "user=root&password=1234");

PS: My password for localhost is 12345678

The connection string will be wrong since you are concatenating user to feedback: jdbc:mysql://localhost//feedbackuser=root&password=1234. — maba
– maba, Commented Apr 4, 2013 at 8:06

Alexandre Jacob · Accepted Answer · 2013-04-04 08:07:07Z

2

You should try

DriverManager.getConnection("jdbc:mysql://localhost/feedback", "root", "1234");

answered Apr 4, 2013 at 8:07

Alexandre Jacob

3,0513 gold badges28 silver badges36 bronze badges

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

Comments

John Jai · Accepted Answer · 2013-04-04 08:08:27Z

2

For better clarity you can use the other overloaded method while getting connection.

Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://<db_ip>/<db_name>", 
    "<username>", "<pwd>");

answered Apr 4, 2013 at 8:08

John Jai

3,8137 gold badges27 silver badges35 bronze badges

Comments

Andrzej Bobak · Accepted Answer · 2013-04-04 10:30:53Z

2

Try

 connect = DriverManager
     .getConnection("jdbc:mysql://localhost/feedback?user=root&password=1234")

(you forgot about the question mark after "feedback")

edited Apr 4, 2013 at 10:30

answered Apr 4, 2013 at 8:07

Andrzej Bobak

2,1303 gold badges28 silver badges36 bronze badges

Comments

Zelldon · Accepted Answer · 2013-04-04 08:15:44Z

1

Many answers but everyone forgot the port of the database.

If you use mysql then try 3306 as db port.
http://www.petefreitag.com/articles/jdbc_urls/ - list of jdbc urls (Examples)

try 
{ 
    conn = DriverManager.getConnection("jdbc:mysql://" + dbHost + ":" + dbPort + "/" + dbName, user, passwd); 
} 
catch(SQLException sqle) 
{ 
    System.out.println("Connection fails: " + sqle.getMessage()); 
}

answered Apr 4, 2013 at 8:15

Zelldon

5,5013 gold badges37 silver badges50 bronze badges

Comments

Aliaksei Bulhak · Accepted Answer · 2013-04-04 08:16:28Z

1

I think you need to use this:

DriverManager.getConnection("jdbc:mysql://localhost:3306/feedback", "root", "1234");

I check my old project and find that I don't use double slash here /feedback.

also you can specify encoding like this :

 DriverManager.getConnection("jdbc:mysql://localhost:3306/feedback?characterEncoding=UTF-8&characterEncoding=Cp1251", "root", "1234");

and also one more advice. Don't use hard code. Get url, password and user name from property files.

edited Apr 4, 2013 at 8:16

answered Apr 4, 2013 at 8:11

Aliaksei Bulhak

6,20810 gold badges49 silver badges77 bronze badges

Comments

Zelldon · Accepted Answer · 2013-04-04 08:27:56Z

1

Try this hope it can help you!!!

Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/feedback?"+"user=root&password=1234");

also see the URL Mistakes like:

jdbc:mysql://localhost//feedback?

// after localhost... check and try my code...

.

edited Apr 4, 2013 at 8:27

Zelldon

5,5013 gold badges37 silver badges50 bronze badges

answered Apr 4, 2013 at 8:14

Arvind Vishwakarma

111 bronze badge

Collectives™ on Stack Overflow

How to specify path to mySQL using localhost?

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related