kodstationen Posted March 25, 2009 Share Posted March 25, 2009 Hi! I'm new to this board, but not new to php or mysql. I have a client that runs a slave database from my master mysql database. However, after a crash on the slave we dumped the master db and my client restored his db from the dump. He started the replication again from my instructions but gets the following error where checking show slave status: "Error 'Access denied; you need the SUPER privilege for this operation' on query." The query is an INSERT statement Isn't this done by the replication user? That user only have replication privileges... Anyont know how to get it right? /Bobo - web developer for Kodstationen AB, Sweden Link to comment https://forums.phpfreaks.com/topic/151043-solved-replication-and-errors-on-slave/ Share on other sites More sharing options...
fenway Posted April 1, 2009 Share Posted April 1, 2009 Wait.. which statment throws that error? Link to comment https://forums.phpfreaks.com/topic/151043-solved-replication-and-errors-on-slave/#findComment-798544 Share on other sites More sharing options...
kodstationen Posted April 1, 2009 Author Share Posted April 1, 2009 I'm sorry about not updating this post since I figured out that it was an trigger that caused the error.The trigger was defined (by the dump) by another user. Adding the user to the slave solved the problem. And I'm sorry that I didn't read the guidlines for the board... :-\ Link to comment https://forums.phpfreaks.com/topic/151043-solved-replication-and-errors-on-slave/#findComment-798557 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.