[ACCEPTED]-Connect to SphinxQL through Linux command-line-sphinx
Accepted answer
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
Use
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 :)
Works for me:
mysql -P 9306 -h 0
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.
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.