I'd like to use HeidiSQL to make fulltext queries on a Sphinx Search Server (http://www.sphinxsearch.com), which has a MySQL-like interface (http://sphinxsearch.com/docs/2.0.2/sphinxql-reference.html).
I can make a connection and run queries, but some errors pop out in the process. Specifically, the SphinxQL does not seem to support the queries
SHOW STATUS LIKE 'Uptime';
SHOW DATABASES;
...
that are being executed after establishing the connection. Sphinx cannot be blamed, since it is not a true MySQL server and probably will never support these.
However, is it possible to define a new session (in the Session manager) in a way that no additional startup commands (even those required to fetch a list of databases) are sent to server? Or perhaps override the default startup commands from a file? I've tried the "Startup script" parameter in the Session manager, but that does not work the way I'd like.