Connect Java with MySQL using Windows Authentication?

Question

Can anyone explain me how to connect Java with MySQL?

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
Connection conn = null;
...
try {
    conn =
       DriverManager.getConnection("jdbc:mysql://localhost/test?" +
                                   "user=monty&password=greatsqldb");

     } 
catch (SQLException ex) 
    {

       System.out.println("SQLException: " + ex.getMessage());
       System.out.println("SQLState: " + ex.getSQLState());
       System.out.println("VendorError: " + ex.getErrorCode());
    }

This is how i made it but mine is windows authentication and not password authentication. So how to complete the connection with windows authentication?

mysql or sqlServer ??? in title it's mysql in tags it's sqlServer — Charaf JRA
– Charaf JRA, Commented Oct 2, 2013 at 9:19
Take a look at this question stackoverflow.com/q/167464/1741542 — Olaf Dietsche
– Olaf Dietsche, Commented Oct 2, 2013 at 9:22

JHS · Accepted Answer · 2013-10-02 09:21:38Z

1

You are not loading the driver class.

Try this -

Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" + "user=monty&password=greatsqldb");

P.S. I have assumed you are using MySQL.

answered Oct 2, 2013 at 9:21

JHS

7,8812 gold badges34 silver badges54 bronze badges

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

Comments

Sumit Gupta · Accepted Answer · 2013-10-02 09:24:55Z

1

First load the driver class

Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/test","monty","greatsqldb");

then create connections.

answered Oct 2, 2013 at 9:24

Sumit Gupta

4474 silver badges12 bronze badges

1 Comment

user2718433 Over a year ago

That's done. But this is for sqlserver authentication. and mine is windows authentication. How to connect with that?

Vimal Bera · Accepted Answer · 2013-10-02 09:33:28Z

0

Try this :

Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/test","monty","greatsqldb");

You can specify the username and password seperately.

FYI : It is not necessary to load the driver using Class.forName() method but to be on safe side, coders use this method to load the drivers.

Read This. It is written that Applications no longer need to explictly load JDBC drivers using Class.forName().

edited Oct 2, 2013 at 9:33

answered Oct 2, 2013 at 9:23

Vimal Bera

10.5k4 gold badges27 silver badges48 bronze badges

Comments

GeertPt · Accepted Answer · 2013-10-02 09:43:43Z

0

I guess you use the MySQL External Authentication for Windows (http://www.mysql.com/products/enterprise/security.html).

This is supported in Connector/Net driver (.NET), using 'Integrated Security=yes' as connection string option: http://dev.mysql.com/doc/refman/5.5/en/connector-net-programming-authentication-windows-native.html

I can't find any documentation about support for this in the Connector/J reference (Java). I guess it's not supported in the Java driver.

answered Oct 2, 2013 at 9:43

GeertPt

18k3 gold badges44 silver badges67 bronze badges

Collectives™ on Stack Overflow

Connect Java with MySQL using Windows Authentication?

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related