I should have looked before I answered. I apologize to you and the rest of the list for having my head up my a**..
I RTFM (http://dev.mysql.com/doc/mysql/en/GRANT.html) and find: The EXECUTION, FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative privileges that can only be granted globally (using ON *.* syntax). So, I guess the answer to your question would be "No". It seems that you cannot assign replication privileges for a client to only one database. This is probably related to the fact that the Master server only keeps one binlog and not one log per database. Humbly yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 07/19/2004 10:15:11 AM: > > Sorry, > > grant REPLICATION SLAVE on forum to repltest2@'%' IDENTIFIED BY > 'replforum'; > ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which > privileges can be used. > > (using 4.20) > > Regard's > Vincent > > -------------------------------------------------------- > You were attempting to grant replication rights to all of the TABLES in > the database "forum". Try it again like: > > grant REPLICATION SLAVE on forum to repl@'%' IDENTIFIED BY 'replforum'; > > and see if it works better ;-) > > Yours, > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > [EMAIL PROTECTED] wrote on 07/19/2004 09:32:29 AM: > > > Trying to setup a new user for replication purpose, here what i got : > > > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 2566 to server version: 4.0.20-standard > > > > > > grant REPLICATION SLAVE on forum.* to repl@'%' IDENTIFIED BY > 'replforum'; > > ERROR 1221: Wrong usage of DB GRANT and GLOBAL PRIVILEGES > > > > grant REPLICATION SLAVE on *.* to repl@'%' IDENTIFIED BY 'replforum'; > > Query OK, 0 rows affected (0.00 sec) > > > > > > Why can't we setup a new user who could have rights on only one (or > two?) > > databases? > > > > > > Regard's > > Vincent > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > >
