Comments - CONNECT MYSQL Table Type: Accessing MySQL/MariaDB Tables
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I wonder why I can't access CONNECT tables when using a non-root? It throws me an error:
ERROR 1045 (28000): Access denied for user 'nonroot'@'%' (using password: YES)
Some CONNECT table types can be used to access arbitrary files on the filesystem, you will need FILE privilege for using these CONNECT table types.
I understand, but I want to use the CONNECT to reference to another MySQL/MariaDB table on a remote machine. I would prefer CONNECT than the FEDERATED/FEDERATEDX engine to do such job. FEDERATED works fine on a non-root.