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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]