Re: help create new user

2002-11-04 Thread Bob Lockie
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 manu

Re: help create new user

2002-11-03 Thread Jeremy Zawodny
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 Magazin

Re: help create new user

2002-11-03 Thread Bob Lockie
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@loc

Re: help create new user

2002-11-03 Thread Jeremy Zawodny
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'

help create new user

2002-11-03 Thread Bob Lockie
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