List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 13 2003 5:54pm
Subject:Re: remote login
View as plain text  
At 18:44 +0100 2/13/03, Branko Kaucic wrote:
>Hi all,
>I have similar problems as Kris posted on 12/17/2002. I didn't find any
>solution, so I write this e-mail.
>If I connect to mysql in console with:
>mysql -u username -p
>then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and
>on the same machine I am trying to connect to database.
>When I use
>mysql -u username -p -h
>it also works fine. But, when I use
>mysql -u username -p -h XXX.XXX.XXX.XXX
>then I got message
>Error 1045: Access denied for user: 'username@machine_name' (Using
>password: YES)
>What should I do??

Issue a GRANT statement that grants access to 'username'@'XXX.XXX.XXX.XXX'.
The existing grant table entries match only localhost and
(apparently), so you'll need to set one up explicitly for XXX.XXX.XXX.XXX.

>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread132321@stripped>
>To unsubscribe, e-mail <>
>Trouble unsubscribing? Try:

remote loginBranko Kaucic13 Feb
  • Re: remote loginMartin Hudec13 Feb
    • Re: remote loginBranko Kaucic13 Feb
  • Re: remote loginPaul DuBois13 Feb