Re: help create new user
Jeremy Zawodny wrote: On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote: That fixed it, thanks. What did it use since I didn't specify an @'localhost'? It used '%' which matches everyhing *except* localhost. The manual explains this. Jeremy It's not obvious in the MySQL manual. I did a search. -- 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
help create new user
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) 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
Re: help create new user
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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 89 days, processed 1,867,398,195 queries (240/sec. avg) - 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
Re: help create new user
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
Re: help create new user
On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote: That fixed it, thanks. What did it use since I didn't specify an @'localhost'? It used '%' which matches everyhing *except* localhost. The manual explains this. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 89 days, processed 1,867,573,876 queries (240/sec. avg) - 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