Connect to SphinxQL through Linux command-line Connect to SphinxQL through Linux command-line mysql mysql

Connect to SphinxQL through Linux command-line


the 'mysql' client, will totally ignore the -P param, if it detects mysql is running on a unix-socket. So really even though you ask for the sphinxQL port, you are connecting to mysql

Use

mysql -P9306 --protocol=tcp

to tell the client to ignore the socket.

Pro Tip:

mysql -P9306 --protocol=tcp --prompt='sphinxQL> '

which serves as a useful ongoing reminder you are connected to sphinx not mysql :)


I ran into this recently. I was able to get in to Sphinx via the mysql shell by commenting out the listen configuration that didn't specify MySQL. This may not work for you, if you still need to get to searchd via the API.