Re: stuck on localhost authentication

2006-08-05 Thread Brad Jahnke
> insert into user (user,host) values ('jeff','localhost'); > flush privileges; > grant all on databaseName.* to jeff; jeff = [EMAIL PROTECTED] not [EMAIL PROTECTED] So in your statement you should have used... grant all on databaseName.* to [EMAIL PROTECTED]; >select user,host from

stuck on localhost authentication

2006-08-05 Thread Jeff Drew
I'm apologize for posting an apparently simple question, but I'm stuck. I'm trying to get my java application to connect to mysql on the same server. The server is redhat with mysql 5.1.11. I'd done this with mysql 4.x in the distant past. I add a user with the command: insert into user (user