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]