Hey Scott,
Try:
GRANT ALL ON DATA.* TO user1@"%" IDENTIFIED BY "password"
/or simply/
GRANT ALL ON DATA.* TO user1 IDENTIFIED BY "password"
Not specifying a domain defaults to %.
HTH
Ben
-----Original Message-----
From: Scott Meesseman [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2001 01:27
To: [EMAIL PROTECTED]
Subject: wildcard character in sql grant statement
Hello,
Is there a new wildcard character in 3.23? I am trying to use the grant
statement
GRANT ALL ON DATA.* TO user1@% IDENTIFIED BY "password"
It doesnt seem to like the % as it returns an sql error
Thanks for your time,
Scott
---------------------------------------------------------------------
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
