[ACCEPTED]-Connect to SphinxQL through Linux command-line-sphinx

Accepted answer
Score: 72

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


mysql -P9306 --protocol=tcp

to tell the client to ignore 3 the socket.

Pro Tip:

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

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

Score: 11

Works for me:

mysql -P 9306 -h 0


Score: 2

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

More Related questions