PHP - MYSQL - test serveur de base de données

J'apprends le PHP, MYSQL et d'essayer de créer une base de données.

Je suis en suivant ce tutoriel
http://www.raywenderlich.com/2941/how-to-write-a-simple-phpmysql-web-service-for-an-ios-app

Jusqu'à présent, je suis en essais pour voir si le serveur a accès à MySQL. Lorsque j'utilise le code suivant.

?php

class RedeemAPI {
   private $db;

   //Constructor - open DB connection
   function __construct() {
       $this->db = new mysqli('localhost', 'username', 'password', 'promos');
    $this->db->autocommit(FALSE);
}

//Destructor - close DB connection
function __destruct() {
    $this->db->close();
}

//Main method to redeem a code
function redeem() {
    //Print all codes in database
    $stmt = $this->db->prepare('SELECT id, code, unlock_code, uses_remaining FROM rw_promo_code');
    $stmt->execute();
    $stmt->bind_result($id, $code, $unlock_code, $uses_remaining);
    while ($stmt->fetch()) {
        echo "$code has $uses_remaining uses remaining!";
    }
    $stmt->close();
   }
} 
//This is the first thing that gets called when this page is loaded
//Creates a new instance of the RedeemAPI class and calls the redeem method
$api = new RedeemAPI;
$api->redeem();

?

J'obtiens l'erreur suivante:

Warning: mysqli::mysqli() [mysqli.mysqli]: [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in /Users/user/Sites/promos/index.php on line 8

Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): No such file or directory in /Users/user/Sites/promos/index.php on line 8

Warning: mysqli::autocommit() [mysqli.autocommit]: Couldn't fetch mysqli in /Users/user/Sites/promos/index.php on line 9

Warning: mysqli::prepare() [mysqli.prepare]: Couldn't fetch mysqli in /Users/user/Sites/promos/index.php on line 20

Fatal error: Call to a member function execute() on a non-object in /Users/user/Sites/promos/index.php on line 21

Je n'ai peut-être oublier de l'activer quelque chose?

Elle pourrait expliquer pourquoi je ne peux pas connecter via mon adresse IP pour sequel pro et uniquement à l'adresse 127.0.0.1?

OriginalL'auteur nimbus | 2012-12-13