The Ultimate Guide to High Availability with MariaDB

Comments - Encoding and access issues

9 years, 5 months ago Olivier Bertrand
Re: Encoding and access issues [Answer]

About your issues:

The access issue is not related to the CONNECT engine. I had the same when trying to access a table with the mysql client. It was fixed by issuing:

FLUSH PRIVILEGES;

After the GRANT command.

The UTF8 issue comes from the fact that when reading the remote table the strings are automatically converted. To fix this issue, just remove the CHARACTER SET UTF8 and DEFAULT CHARSET=utf8 COLLATE=utf8_bin from the declaration of the CONNECT table.

 
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.