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