[ACCEPTED]-Connect to SphinxQL through Linux command-line-sphinx
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.
mysql -P9306 --protocol=tcp --prompt='sphinxQL> '
which serves as a useful 2 ongoing reminder you are connected to sphinx 1 not mysql :)
Works for me:
mysql -P 9306 -h 0
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