JDBC connection with MYSQL5.1

Question

I am trying jdbc connection with mysql but getting SQLException.

My code is:--

public void createConn() throws MysqlException {

    try {
                String url ="jdbc:mysql://172.168.1.73:3306/mysql";
                Connection con =DriverManager.getConnection(url,"root", "");
                System.out.println("URL: " + url);
                System.out.println("Connection: " + con);
        }

i am getting following exception...

java.sql.SQLException: Access denied for user 'root'@'192.168.1.187' (using password: NO)

I am trying to connect to 172.168.1.73 but it is trying to coonect to 192.168.1.187...

root user doesnt have any password.

Please tell me how can i solve this issue.

What is your database schema name? Is it mysql?

Lion
– Lion

2012-01-05 04:12:53 +00:00
Commented Jan 5, 2012 at 4:12 — Lion
– Lion, Commented Jan 5, 2012 at 4:12

Manjula · Accepted Answer · 2012-01-05 04:16:42Z

2

Check whether root user can access the machine with IP 192.168.1.187

It is not trying to connect to 192.168.1.187.

'root'@'192.168.1.187' in the exception means a user with user name "root" in the machine with IP '192.168.1.187' trying to access the database server. Therefore 192.168.1.187 is the client IP.

Database servers restricts the access based on user and the IP of the machine user use to connect. Therefore if you want to connect to the database server from a IP '192.168.1.187', you should grant permission to access the user to access from that specific IP.

Check MySQL GRANT for more details.

edited Jan 5, 2012 at 4:16

answered Jan 5, 2012 at 4:11

Manjula

5,1413 gold badges31 silver badges42 bronze badges

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

4 Comments

Bhesh Gurung Over a year ago

Exactly what I was thinking. +1.

Anjali Over a year ago

thanks for the help...its working now. root doesnt have access to 192.168.1.187 IP...

Anjali Over a year ago

I wanted to know how can i get to know that which database is accessible to which user????

Manjula Over a year ago

In mysql database server, there is a schema named "mysql". In that schema, there is a table named "User". You can find the mysql user details and granted permissions in that table. and see the "db" table for database specific users and user privileges. Please note that "%" in "host" field means that user can access from any IP.

Sovandara Choum · Accepted Answer · 2012-01-05 04:17:31Z

0

To be more secure, you need to assign the root password and try it again. The page below contains Java code to connect to mysql database: http://www.worldbestlearningcenter.com/index_files/java_database_connect_mysql.htm

answered Jan 5, 2012 at 4:17

Sovandara Choum

1

Collectives™ on Stack Overflow

JDBC connection with MYSQL5.1

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related