stinkingpig Wrote: 
> Patrick Dixon wrote:
> > Hmm, well I've spent the 5 minutes and I'm getting nowhere ...
> >
> > I'm getting:
> >
> > mysql> Ungrant all on slimserver.* to slimserver [identified by
> > 'password'];
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the
> > manual that corresponds to your MySQL server version for the right
> > syntax to use near 'Ungrant all on slimserver.* to slimserver
> > [identified by 'password']' at line 1
> >
> > and I have no idea what any of it means!
> >
> >
> >   
> try this:
> 
> mysql> grant all on slimserver.* to [EMAIL PROTECTED] identified by
> 
> 'password';
> 
> the wiki forgets to specify where the user is, and assumes that people
> 
> know what [] means (it means --identified by 'password'-- is
> optional).
> 
> -- 
> Jack at Monkeynoodle dot Org: It's a Scientific Venture...
> Riding the Emergency Third Rail Power Trip Since 1996


Thanks Jack.  I got it working using:
GRANT ALL PRIVILEGES ON slimserver.* TO 'slimserver'@'localhost';

(The wiki also uses 'Ungrant', for some reason I really don't
understand!)


-- 
Patrick Dixon

www.at-tunes.co.uk
------------------------------------------------------------------------
Patrick Dixon's Profile: http://forums.slimdevices.com/member.php?userid=90
View this thread: http://forums.slimdevices.com/showthread.php?t=20281

_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to