How do I connect to MySQL with PHP?

UNIX Socket (Recommended)

$db_host     = 'localhost';
$db_user     = 'root';
$db_password = 'root';
$db_db       = 'information_schema';

$mysqli = new mysqli(
  $db_host,
  $db_user,
  $db_password,
  $db_db
);

if ($mysqli->connect_error) {
  echo 'Errno: ' . $mysqli->connect_errno;
  echo '<br>';
  echo 'Error: ' . $mysqli->connect_error;
  exit();
}

echo 'Success: A proper connection to MySQL was made.';
echo '<br>';
echo 'Host information: ' . $mysqli->host_info;
echo '<br>';
echo 'Protocol version: ' . $mysqli->protocol_version;

$mysqli->close();

TCP/IP

$db_host     = '127.0.0.1';
$db_user     = 'root';
$db_password = 'root';
$db_db       = 'information_schema';
$db_port     = 8889;  // MAMP PRO default; use 3306 if you have set standard ports

$mysqli = new mysqli(
  $db_host,
  $db_user,
  $db_password,
  $db_db,
  $db_port
);

if ($mysqli->connect_error) {
  echo 'Errno: ' . $mysqli->connect_errno;
  echo '<br>';
  echo 'Error: ' . $mysqli->connect_error;
  exit();
}

echo 'Success: A proper connection to MySQL was made.';
echo '<br>';
echo 'Host information: ' . $mysqli->host_info;
echo '<br>';
echo 'Protocol version: ' . $mysqli->protocol_version;

$mysqli->close();

---

← MySQL how-to guides