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, Oct 02 '13 at 09:19
Take a look at this question http://stackoverflow.com/q/167464/1741542 — Olaf Dietsche, Oct 02 '13 at 09:22
possible duplicate of [Java connectivity with MySQL](http://stackoverflow.com/questions/2839321/java-connectivity-with-mysql) — Eel Lee, Oct 02 '13 at 09:27

score 1 · Answer 1 · answered Oct 02 '13 at 09:21

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 02 '13 at 09:21

JHS

7,761
2
29
53

score 1 · Answer 2 · answered Oct 02 '13 at 09:24

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 02 '13 at 09:24

Sumit Gupta

437
4
12

That's done. But this is for sqlserver authentication. and mine is windows authentication. How to connect with that? – user2718433 Oct 02 '13 at 10:05

Vimal Bera · Answer 3 · 2013-10-02T09:33:28.803

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().

score 0 · Answer 4 · answered Oct 02 '13 at 09:43

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.

Connect Java with MySQL using Windows Authentication?

4 Answers4