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