At 14:58 -0400 4/19/02, Barry C. Hawkins wrote: >Alex, > Enclose the user string in quotes. This will allow you to use >the global wildcard option. > >Example: >GRANT ALL ON *.* TO "myuser@%" IDENTIFIED BY "mypassword";
You should quote the user name and host name parts separately. "myuser"@"%" > > For those not using Mac OS X, the default shell is tcsh. I am >not sure if this quirk is a function of string handling in tcsh or >what, but this is the workaround I am using. The shell doesn't have anything to do with how MySQL interprets the GRANT statement. ?? > >Happy granting, >-- >Barry C. Hawkins >Systems Consultant >All Things Computed >[EMAIL PROTECTED] > > > >On Fri, 19 Apr 2002 13:45:56 -0400 Alex Pilson ><[EMAIL PROTECTED]> wrote: > >Why is this producing a syntax error at the %? This is supposed to >create a global user, yes? > >GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword"; > >Is there a quick command to show all GRANTS? or Users? >-- --------------------------------------------------------------------- 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