Jeremy Zawodny wrote:

On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote:

Does anyone know why?

create database visitor;
grant all on visitor.* to visitor_user identified by 'visitor';
use visitor;

mysql -u visitor_user -p

I get "ERROR 1045: Access denied for user: 'visitor_user@localhost' (Using password: YES)"

Try:

grant all on visitor.* to visitor_user@'localhost' identified by 'visitor';

Jeremy

That fixed it, thanks.
What did it use since I didn't specify an @'localhost'?

--
----------------------------------------
From Mozilla and GNU/Linux


---------------------------------------------------------------------
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

Reply via email to