I am try to replicate a couple of databases that use InnoDB tables.
I have followed the standard replication instructions, inasmuch as
they exist for InnoDB, but every time I try and start the slave I get
Error 'Access denied; you need the SUPER privilege for this operation'
Indeed, even attempting to insert into a replica table as root gives
the same error.
Is it the case that any InnoDB tables must have their own
ibd files in order for replication to succeed?
Julian Rawcliffe | Senior Infrastructure Engineer | Information Systems
London Business School | Regent's Park | London NW1 4SA | United Kingdom
Switchboard +44 (0)20 7000 7000 |
Direct line +44 (0)20 7000 7782 |
Mobile +44 (0) 7966 907782 |
This email has been scanned by the MessageLabs Email Security System
on behalf of the London Business School community.
For more information please visit http://www.messagelabs.com/email