On 23 May 2014, at 17:38, Federico Razzoli <[email protected]> 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
