duanmi8349 2014-02-09 21:06
浏览 43
已采纳

PHP无法连接到Live Site上的Sphinx

I get the error "Warning: mysqli::mysqli(): (HY000/2005): Unknown MySQL server host '127.0.0.1:9306' (0)". According to the netstat command the port 9306 is open but it can't connect via PHP or the command prompt. The command prompt connects to MySQL on port 9306 instead of connecting to sphinx.

The code that causes this is:

$sphinx = new mysqli('127.0.0.1:9306');

This is on Linux and the Sphinx version is 2.0.4. Other versions including 2.2.1 have been tried.

Can anyone help me get this working?

This is my first question so let me know if I need to change the format of this question.

  • 写回答

1条回答 默认 最新

  • dtot74529 2014-02-09 21:47
    关注

    Re the command-line client, you probably need to explicitally tell it use tcp

    mysql -P 9306 --protocol=tcp
    

    Its counter-intutive, that the mysql client will silentiy ignore the -P param, if it finds a mysql server on the local machine.

    And as for PHP, no idea if what you have should work, but I tend to use

    $sphinx = new mysqli("127.0.0.1", "", "", "", 9306);
    

    which works for me.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥50 汇编语言除法溢出问题
  • ¥65 C++实现删除N个数据列表共有的元素
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波