List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 29 1999 9:09pm
Subject:Re: User Error
View as plain text  
At 3:56 PM -0500 8/29/99, Sandeep Sawhney wrote:
>HI
>
>i created a  database called HITJOBS
>and added this info for it
>
>insert into user (host,user,password)
>values('localhost','hitjobs1',password('hobxxx'));
>
>insert into db (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,
>        Create_priv,Drop_priv)  values
>'localhost','hitjobs','hitjobs1','Y','Y','Y','Y','Y','Y');
>
>when i try to connect to it
>
>localhost:/usr/local/mysql/bin$ mysql hitjobs -u hitjobs -p
>Enter password:
>
>i put in hobxxx i get
>ERROR 1045: Access denied for user: 'hitjobs@localhost' (Using password: YES)
>
>what could i be doing wrong ..


For one thing, you put a user name of "hitjobs1" into the user
table, but you try to connect as "hitjobs" - not the same user name.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
User ErrorSandeep Sawhney29 Aug
  • Re: User ErrorMartin Ramsch29 Aug
  • Re: User ErrorPaul DuBois29 Aug
  • User ErrorMichael Widenius29 Aug