doushuhuai7247 2016-07-27 21:24
浏览 80

无法使用MySQLI连接到远程MySQL数据库 - 超时

I have created two servers on Linux and installed LAMP on both, one I called web and the other is called app.

I would like to save a log from the web server on the app server - but when I try to connect to the app server, I get timeout.

My code is:

$mysqli = mysqli_connect("66:66:666:66", "username", "pass", "DB");
    if (!$mysqli) {
        die("Connection failed: " . mysqli_connect_error());
    }

Where 66:66:666:66 is the ip to the app server.

I have in the app server under PhpMyAdmin added user privileges to a user with the name "username" and then the host is "%".

Have i forgotten something?

Edit: I have already tried to add port number 3306 to the connection.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥85 maple软件,solve求反函数,出现rootof怎么办?
    • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名
    • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
    • ¥65 汇编语言除法溢出问题
    • ¥15 Visual Studio问题
    • ¥20 求一个html代码,有偿
    • ¥100 关于使用MATLAB中copularnd函数的问题