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]

Reply via email to