| Bug #18872 | GRANT statement fails to replicate | ||
|---|---|---|---|
| Submitted: | 7 Apr 2006 2:10 | Modified: | 10 May 2006 11:01 |
| Reporter: | Peter Zaitsev (Basic Quality Contributor) | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 4.1.15 | OS: | Any (all) |
| Assigned to: | CPU Architecture: | Any | |
[10 Apr 2006 11:01]
Valeriy Kravchuk
Thank you for a problem report. Please, send replication-related my.cnf settings from master and slave. Can you try to repeat with a newer version of MySQL server, 4.1.18?
[10 May 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: Certain GRANT tables may fail replicating: # mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 46 to server version: 4.1.14-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant replication slave on * to repl@127.0.0.1 identified by "password"; Query OK, 0 rows affected (0.05 sec) Note MySQL is started without active database: Slave: Last_Errno: 1221 Last_Error: Error 'Incorrect usage of DB GRANT and GLOBAL PRIVILEGES' on query. Default database: ''. Query: 'grant replication slave on * to repl@127.0.0.1 identified by "password"' Skip_Counter: 0 How to repeat: See above.