JDBC Hibernate - Mysql Connection Error

Question

I have a local mysql server on my Ubuntu 11.10 desktop. The hostname = localhost; username = root; password = root; database name = CBS. I am really confused because when I access mysql using terminal, mysql administrator, and mysql query browser I use those authentication I mentioned above and everything is OK. My problem is when I configure my jdbc.properties in my Java App I'm getting this error:

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [28000]; error code [1045]; Access denied for user 'root '@'localhost' (using password: YES); nested exception is java.sql.SQLException: Access denied for user 'root '@'localhost' (using password: YES)

My configuration file, jdbc.properties:

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/CBS
jdbc.username=root  
jdbc.password=root

By the way, the reason I will be using local server because our main server shutdown so I have to use my local mysql to continue with my project. Please help me... Thanks in advance.

What is your hostname when using mysql adminstrator (or the other tools)? As duffymo mentioned below you may have a grant issue with that user connecting to localhost. I didn't see any mention about the hostname in the first part of your message. — jmq
– jmq, Commented Feb 15, 2012 at 23:57
do you run your "java app" using root creds ? when youy app runs - check it out using "ps -ef | grep <java app name>" and see which user is running it - in case it's not "root" you have your answer right there. — Nir Alfasi
– Nir Alfasi, Commented Feb 15, 2012 at 23:59

Perception · Accepted Answer · 2012-02-16 00:16:41Z

5

More than likely your framework is logging into your local database as 127.0.0.1. Which will create a login problem in MySQL if you have not defined an appropriate domain scoped credential. Try this to verify:

mysql -uroot -proot
SELECT * from mysql.user WHERE user = 'root';

If there is no 'root'@'127.0.0.1' then have found the problem and to remedy it, do one of two things:

Define a domain scoped credential for 'root', at '127.0.0.1'.
Define a wildcard domain scoped credential for 'root', so you can login to your MySQL with those credentials from multiple locations.

Here's an example of the second:

mysql -uroot -proot

CREATE USER 'root'@'%' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

On a side note, I would definitely recommend using something more creative for your user id and password. Especially if you have TCP sockets enabled for your server.

edited Feb 16, 2012 at 0:16

answered Feb 15, 2012 at 23:59

Perception

80.8k19 gold badges190 silver badges197 bronze badges

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

8 Comments

NinjaBoy Over a year ago

When I ran the command SELECT * from users WHERE user = 'root'; what database will I use to see if I have a 'root'@'127.0.0.1'? Im new to this.

Perception Over a year ago

Actually, the command is select * from mysql.user where user = 'root';. I updated my answer.

NinjaBoy Over a year ago

Perception Over a year ago

Eh, do me a favor and execute this in mysql select user, host from user, and tell me how many rows show up with user 'root', and what the host field for the rows are.

NinjaBoy Over a year ago

I have 8 rows. I saw user = root and host = localhost.

|

duffymo · Accepted Answer · 2012-02-16 00:23:40Z

3

You might have to GRANT permissions to access the database.

Look at the MySQL docs for something that looks like this:

create database pmt;
create user pmt identified by 'pmt';
grant all on pmt.* to 'pmt'@'%';

"pmt" is just an example above. I happened to make the name of the database, username, and password all the same. I don't recommend that as a best practice. It's just something I did for some local development.

I personally don't like GRANTing root access to any application. I would not use root username and password in even a toy application. It doesn't take much effort to create a new user and GRANT appropriate permissions.

edited Feb 16, 2012 at 0:23

answered Feb 15, 2012 at 23:50

duffymo

310k46 gold badges376 silver badges571 bronze badges

1 Comment

NinjaBoy Over a year ago

Do I have to restart my server after executing those commands?

Collectives™ on Stack Overflow

JDBC Hibernate - Mysql Connection Error

2 Answers 2

8 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related