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"; 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. 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? -- <-------------------------------------------------> Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macromedia Director/Flash Authoring <-------------------------------------------------> --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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