View Single Post
  #26  
Old 9th October 2010, 22:05
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 39 Times in 33 Posts
Default Slave Server permissions

I updated the slave first and then the master.

I'm getting these warnings on the slave mirror:
Quote:
2010-10-09 20:28 debian1.badbison.co.uk Warning DB::query(SELECT action_id, action_type, action_param FROM sys_remoteaction WHERE server_id = 2 AND action_id > 0 ORDER BY action_id) -> mysql_query SELECT command denied to user 'ispcsrv2'@'192.168.0.101' for table 'sys_remoteaction' Delete
2010-10-09 20:27 debian1.badbison.co.uk Warning DB::query(SELECT action_id, action_type, action_param FROM sys_remoteaction WHERE server_id = 2 AND action_id > 0 ORDER BY action_id) -> mysql_query SELECT command denied to user 'ispcsrv2'@'192.168.0.101' for table 'sys_remoteaction' Delete
2010-10-09 20:26 debian1.badbison.co.uk Warning DB::query(SELECT action_id, action_type, action_param FROM sys_remoteaction WHERE server_id = 2 AND action_id > 0 ORDER BY action_id) -> mysql_query SELECT command denied to user 'ispcsrv2'@'192.168.0.101' for table 'sys_remoteaction' Delete
2010-10-09 20:25 debian1.badbison.co.uk Warning DB::query(SELECT action_id, action_type, action_param FROM sys_remoteaction WHERE server_id = 2 AND action_id > 0 ORDER BY action_id) -> mysql_query SELECT command denied to user 'ispcsrv2'@'192.168.0.101' for table 'sys_remoteaction'

Using phpmyadmin 'ispcsrv2'@'192.168.0.101' has usage only permissions. Is this correct?

Thanks

David
Reply With Quote