From: bruce (bedouglasearthlink.net)
Date: Sat Jul 03 2004 - 02:27:42 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]