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 127.0.0.1
>
>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 127.0.0.1
(apparently), so you'll need to set one up explicitly for XXX.XXX.XXX.XXX.

>
>Thanks,
>Branko
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread132321@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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