On 23 May 2014, at 17:38, Federico Razzoli <federico_raz@yahoo.it> 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_sq... -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles