I'm using 4.0.9 and I can not grant replication slave. [EMAIL PROTECTED] root]# rpm -qf /usr/bin/mysql MySQL-client-4.0.9-0 [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysql mysqld mysqld-max [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysqld-max MySQL-Max-4.0.9-0 [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysqld MySQL-4.0.9-0
mysql> grant replication slave on *.*to [EMAIL PROTECTED] identified by 'replicon01'; mysql> show grants for [EMAIL PROTECTED]; +----------------------------------------------------------------------------------+ | Grants for [EMAIL PROTECTED] | +----------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'test01'@'a.com' IDENTIFIED BY PASSWORD '65907ecf00036cf9' | +----------------------------------------------------------------------------------+ 1 row in set (0.00 sec) I have 2 other 4.0.9 machines where this works perfectly. I'm worried one of my machines didn't fully upgrade to 4.0.9. Suggestions? Thank you. -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web Start: http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
