Can't connect to MySQL server on 'XX.XX.XX.XX' (13)

Posted August 11, 2018 3.4k views

Hello dear experts!!!

Need help!


Have a test table in DB, that contain tow strings:

Have a test script, that works if I lounch it from cmd:

$ php test.php
<html><header></header><body>test page<br>qwe - asd
rty - fgh

So, MySQL+PHP works!!!

Have info.php file in the root dir of nginx, that works too (I see page in browser).
So, Nginx+PHP works too!!!

But, when I request test.php by http, browser (and curl too) returns that:
Can’t connect to MySQL server on 'XX.XX.XX.XX’ (13)

I have installed LEMP twice with the same result by using this instruction:

Several hours in internet didn’t provide any answers!
Thanks for help!

1 comment
  • P.S.
    If someone would like to test, here are scripts:

    create table a_first (request varchar(30), answer varchar(30)) ;
    insert into a_first values ('qwe','asd') ;
    insert into a_first values ('rty','fgh') ;
    $dbname="dbname" ;
    echo "<html><header></header><body>";
    require_once 'db.php';
    echo "test page" ;
    echo "<br>" ;
    // Create connection
    $conn = mysql_connect($servername, $username, $password);
    if (!$conn) {
        die('cani\'t connect: ' . mysql_error());
    $db_selected = mysql_select_db($dbname, $conn);
    if (!$db_selected) {
        die ('can\'t select DB: ' . mysql_error());
    $sql = "select * from a_first; " ;
    $result = mysql_query($sql);
    if (!$result) {
        die('SQL error: ' . mysql_error());
    while ($row = mysql_fetch_assoc($result)) {
        echo $row['request']." - ".$row['answer']." \n";
        echo "<br>\n" ;
    echo "</body></html>";

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

setsebool -P httpdcannetworkconnectdb 1