maria-discuss team mailing list archive

[Colin Charles <colin@xxxxxxxxxxx>]

On 23 May 2014, at 17:38, Federico Razzoli <federico_raz@xxxxxxxx> wrote:

> Hi all.
> Can a SPIDER table, on MariaDB 10.0, connect to a remote MySQL 5.5 table? I can't find this info.

Yes it can. I've done this from 10.0 -> mysql 5.5 (spiderformysql release). Adding Kentoku just in case. This was all spider 3.x branch

> If it can, I have a problem I don't understand. I can create the table, but when I execute any query I get:
> 
> ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
> 
> (which is misleading in any case, since I have SUPER)
> 

verified thru show grants?
Turn on the spider logs to see as well
https://mariadb.com/kb/en/spider-server-system-variables/#spider_internal_sql_log_off



--
Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company 
blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles