hi...
i have a user that i've created
mysql> insert into user (host,user,password)
-> values ('192.168.1.%', 'test', password('XXXXXX'));
Query OK, 1 row affected (0.00 sec)
mysql> insert into db (host,db,user,select_priv)
-> values ('192.168.1.%', 'temp', 'test', 'Y');
Query OK, 1 row affected (0.00 sec)
i'd like to be able to add additional privs...
i've tried the following but it doesn't seem to work...
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON temp.*
-> TO 'test'@'192.168.1.%'
-> IDENTIFIED BY 'passwd';
mysql continues to say that 0 rows affected...
the mysql docs and other sites i've seen seem to suggest that this is a
valid way to add additional privs to a user.
any idea as to what i'm missing...
thanks..
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
