Hibernate, JDBC, Mysql, Cannot login into database

Question

When i connect with this code on my linux (Ubuntu 11.10) with mysql version 5.1 it works fine, but when i want to start my app on windows os (windows 7 with mysql 5.5) it throws exception:

org.hibernate.exception.GenericJDBCException: Cannot open connection

In both cases i was log in on localhost. I tried to log in on root user. I have complete certainty it was correct password. I tried to grand a all priviligates to new one user, but it was the same exception. Another option i was try was that i catch a GenericJDBCException and program gives me this:

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

I connect to database programmatically (via Hibernate AnnotationConfiguration):

annotationConfiguration = new AnnotationConfiguration();
annotationConfiguration.setProperty("hibernate.hbm2ddl.auto", "create");

// add annotatedClasses
annotationConfiguration.addAnnotatedClass(X.class);

annotationConfiguration.setProperty("hibernate.dialect", "net.sf.hibernate.dialect.MySQLDialect");
annotationConfiguration.setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver");
annotationConfiguration.setProperty("hibernate.connection.url", "jdbc:mysql://" + host + ":3306/" + database);
annotationConfiguration.setProperty("hibernate.connection.username", userName);
annotationConfiguration.setProperty("hibernate.connection.password", password);
annotationConfiguration.setProperty("hibernate.connection.release_mode", "auto");
//annotationConfiguration.setProperty("hibernate.query.factory_class", "org.hibernate.hql.classic.ClassicQueryTranslatorFactory");
if (StaticConstants.DEBUG) {
    annotationConfiguration.setProperty("hibernate.show_sql", "true");
} else {
    annotationConfiguration.setProperty("hibernate.show_sql", "false");
}
annotationConfiguration.configure();
sessionFactory = annotationConfiguration.buildSessionFactory();
sessionFactory.close();

I use Hibernate version 3.6.7, but i tested it on Hibernate 3.6.8 via Configuration class and it was the same result.

So my question is has someone the same problem and solve it, or anyone have any idea to solve it?

Thanks

Can you connect to the database using commandline? i.e. mysql -u root -p — Sid Malani
– Sid Malani, Commented Dec 14, 2011 at 9:51
no... but i should :) i check that but the same code works on linux — Michał Skóra
– Michał Skóra, Commented Dec 14, 2011 at 10:00

WeMakeSoftware · Accepted Answer · 2011-12-14 09:50:23Z

1

check your credentials. your password for user root is wrong

answered Dec 14, 2011 at 9:50

WeMakeSoftware

9,1825 gold badges37 silver badges52 bronze badges

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

8 Comments

WeMakeSoftware Over a year ago

the exception clearly says that a user root has tried to connect to the database with some password and MySQL didn't allow it

WeMakeSoftware Over a year ago

Check if you're authenticating against proper database. You may have several instances running in your environment

Michał Skóra Over a year ago

yes, you have right, but maybe there is some problem with hibernate or something like that - thats why i wrote here.

WeMakeSoftware Over a year ago

I mean several instances of MySQL running. This is not a code problem, but rather a configuration problem. Did you flush the privileges after you've granted them? Did you try to restart Mysql after granting the privileges?

WeMakeSoftware Over a year ago

try the following: connect from command prompt and issue commands manually: create user testUser grant all privileges on database_name.* to 'testUser'@* identified by 'testPassword' // note the star at the end of the database name flush privileges // this is really important Change your java code to reflect the new credentials. Launch the app.

|

aruns · Accepted Answer · 2011-12-14 10:53:18Z

1

First try login into mysql installed on win 7 from the command prompt. Open command promt.Move to the bin folder of mysql installation.

C:\mysql\bin>mysql.exe -u root -p

Above line will prompt for password.Input password and see if you are able to login correctly

answered Dec 14, 2011 at 10:53

aruns

4181 gold badge5 silver badges12 bronze badges

Collectives™ on Stack Overflow

Hibernate, JDBC, Mysql, Cannot login into database

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related