error with deploying spring hibernate mysql connection

Question

hi my app is based on spring-hibernate.Database is mysql. I imported my db with phpmyadmin in jelastic. hibernate connection detail

 <property name="url"
                value="jdbc:mysql://mysql-estate.jelastic.servint.net/realestate" />
            <property name="username" value="root" />
            <property name="password" value="password" />

after i deployed my war file and shows following error on browser..

message Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'192.168.3.21' (using password: YES))

Did you give proper permissions to the root user in Mysql?

Matei Florescu
– Matei Florescu

2014-05-30 14:16:53 +00:00
Commented May 30, 2014 at 14:16 — Matei Florescu
– Matei Florescu, Commented May 30, 2014 at 14:16
how do i set permssion on phpmyadmin

boycod3
– boycod3

2014-05-30 14:30:30 +00:00
Commented May 30, 2014 at 14:30 — boycod3
– boycod3, Commented May 30, 2014 at 14:30

zmf · Accepted Answer · 2014-05-30 14:16:32Z

2

Mysql won't allow root connections from any host by default. You've got to whitelist account access. A better way to do this would be to create a mysql user for your application, and give that user remote login privileges.

Here's how you do that: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass'; GRANT ALL ON db1.* TO 'jeffrey'@'localhost';

Note that when specifying a user you are required to specify a host.

answered May 30, 2014 at 14:16

zmf

9,3632 gold badges29 silver badges29 bronze badges

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

2 Comments

zmf Over a year ago

yes url is correct, the error message you're receiving indicates that you are connecting to the database, but the credentials you're using are not valid. you need to allow access to the database from a specific user and host.

boycod3 Over a year ago

cleared above problem. now it is showing java.net.UnknownHostException: mysql.hibernate.estate.jelastic.servint.net error....!! my environment name:-estate.jelastic.servint.net/ i refereed the link docs.jelastic.com/jelastic-db-hibernate

Collectives™ on Stack Overflow

error with deploying spring hibernate mysql connection

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related