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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php