I am having problems setting up replication between two 4.0.10
servers.
What I did so far:
- generate a dump of the current state of the server using
'mysqldump' (its a mix of mostly innodb tables and some MyISAM
tables)
- dropped all databases from the slave
- imported the dump into
On Thursday 13 February 2003 16:43, Johannes Ullrich wrote:
I am having problems setting up replication between two 4.0.10
servers.
What I did so far:
- generate a dump of the current state of the server using
'mysqldump' (its a mix of mostly innodb tables and some MyISAM
tables)
-
Check the user 'repl' has REPLICATION SLAVE privilege.
Ah. that fixed it. Actually, the real reason was that I had not
yet updated the mysql tables and the new privileges did not take
effect as a result.
mysql_fix_privilege_tables , followed by the 'GRANT' command
and 'flush privileges' fixed