How to prevent Hibernate from appending hostname to username with MySQL

Question

I'm using Hibernate with JPA and MySQL.

I got accessing denied.

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

I know the username/password are ok. The problem is that is that the driver is appending @'hostname' at the end. How can I prevent that?

But the grant is only for username, and the machine are different, so I can't grant for every hostname. (I don't care if it's secure or not, it's a dev server).

I created the database that way:

create database mydbname character_set utf8 collate utf8_general_ci;
GRANT ALL ON mydbname.* TO username IDENTIFIED BY 'password';

LabOctoCat · Accepted Answer · 2012-04-07 21:28:13Z

2

You need grant to all machines that must access to MySQL.

If you have to many machines and you don't want grant every one you can do:

GRANT ALL ON mydbname.* TO username@'%' IDENTIFIED BY 'password';

or

GRANT ALL ON mydbname.* TO username@'192.168.1.%' IDENTIFIED BY 'password';

I you don't do this the clients won't be able to connect to your database

For more info: http://dev.mysql.com/doc/refman/5.1/en/grant.html

edited Apr 7, 2012 at 21:28

LabOctoCat

6207 silver badges18 bronze badges

answered Apr 7, 2012 at 16:58

Ernesto Campohermoso

7,4411 gold badge42 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

How to prevent Hibernate from appending hostname to username with MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related