How do I get mysqli_connect() to work?

Question

While running this simple script:

<?php
$link = mysqli_connect("localhost", "*****", "********", "***");
if (!$link) {
  printf("Connect failed: %s\n", mysqli_connect_error());
  exit();
  }
printf("Host information: %s\n", mysqli_get_host_info($link));
mysqli_close($link);
?>

on my networksolutions account I received this error

Connect failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I called network solutins tech support twice. They "re synchronized" the server and we reverified the "connection strings" the function parameters...but no go. I tried switching from mysql_connect() to mysqli_connect().

I don't know what it could be. I know there must by thousands of NS customers who do this but did not find an answer on their forum.

Please help. Anyone interested in working for equity in my website please let me know as well.

Thanks

can you give some information about your system? what OS, is MySQL installed from metapackage? did you change the configurations at all in my.cnf? — KeatsKelleher, Nov 02 '10 at 21:12

score 1 · Answer 1 · answered Jun 24 '12 at 05:20

Below code may be help!

<?php
/*SERVER database connection*/
    function dbconnect(){
    $connection = mysql_connect('localhost','****','****);
        if(!$connection){
        return false;
        }
        if(!mysql_select_db('database_name')){
        return false;
        }
        return $connection;
    }
?>

score 1 · Answer 2 · answered Aug 07 '13 at 12:40

Try using PDO used this example as your basis

    <?php
     $orig = $_GET['orig'];
     $des_id = $_GET['des_id'];
            try {
                $dbuser = "kim";
                $dbpass = "kim";
    $conn = new PDO('mysql:host=localhost;dbname=destination', $dbuser, $dbpass);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    
    $stmt = $conn->prepare("SELECT pl_id FROM view_places WHERE name = :name LIMIT 1");

                $stmt->bindParam(':name',$orig); 
                $stmt->execute();
                $result_1 = $stmt -> fetch();
                $res1 = $result_1["pl_id"];  

                $stmt->bindParam(':name', $des_id); 
                $stmt->execute(); 
                $result_2 = $stmt -> fetch(); 
                    $res2 = $result_2["pl_id"];  
                    echo   'origin_number:'.$res1. ', '.'destination_id:'.$res2;
                }   catch(PDOException $e) {
                        echo 'ERROR: ' . $e->getMessage();
                }

            ?>

score 1 · Answer 3 · edited May 23 '17 at 12:29

1

Try 127.0.0.1 instead of localhost to make the connection using TCP/IP rather than through the local socket, which seems to be broken for one reason or another.

Background

edited May 23 '17 at 12:29

Community

1
1

answered Nov 02 '10 at 21:10

Pekka

442,112
142
972
1,088

score 0 · Answer 4 · answered Nov 02 '10 at 21:11

0

Are you sure it should be localhost? I know that Dreamhost does not allow localhost connections to go through -- you have to connect to mysql.example.com.

answered Nov 02 '10 at 21:11

Christian Mann

8,030
5
41
51

score 0 · Answer 5 · answered Nov 02 '10 at 21:15

Let them know that they not only need to set the proper mysql plugin default socket, but the mysqli plugin default socket.

From my server's php.ini config:

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket  = "/var/lib/mysql/mysql.sock"
mysqli.default_socket = "/var/lib/mysql/mysql.sock"

Thus both must be set. I bet they didn't set mysqli.default_socket.

How do I get mysqli_connect() to work?

5 Answers5