mysql_connect

Synopsis

Returns

MySQL link on success; FALSE on failure

Description

mysql_connect() is used to connect to a local or remote MySQL server. Normally it's used as follows:

   $mysql_link = mysql_connect ('some_host', 'some_user', 'some_password');

The host argument should contain a domain name or an IP address, optionally followed by a port number. If no port number is specified, the default MySQL port of 3306 is assumed. If connecting tolocalhost on a UNIX-like operating system, a path to the local MySQL socket can also be specified, in the form localhost: /path/to/socket - execute a show variables like 'socket' query to find the location of the socket.

If the host argument is not specified, the value of the mysql.default_host configuration directive is used. If this directive is not set, localhost is used. Default values for the port and socket components of the host argument can be specified using the mysql.default_port and mysql.default_socket configuration directives.

The user_name argument should contain the name of the user to authenticate. If user_name is not specified, the value set for the mysql.default_user configuration directive is used. If this directive is not set, the name of the user that PHP is currently running as is used.

The password argument should contain the password to use for the login attempt. If this argument is not specified, the value set for mysql.default_password is used. If this directive is not set, an empty string ("") is used.

If sql.safe_mode is enabled, mysql_connect() and mysql_pconnect() ignore any arguments passed to them. Instead, the functions attempt to connect to a MySQL server on localhost as the user that PHP runs as, with no password.

Duplicate calls to mysql_connect() from within the same script return the same mysql link.

Connections opened by mysql_connect() are closed at script exit, unless closed earlier by calls to mysql_close() .

Version

PHP 3+, PHP 4+

See also

Example

<?php
mysql_connect ()
    or die ("Could not connect to a MySQL server using the default settings.");

echo "Successfully connected to a MySQL server using the default settings.";
?>

<?php
$host = 'mysql.example.com';
$port = '13306';
$user = 'some_login';
$pass = 'some_password';

// Suppress errors with a single ampersand (@)
// Handle failure to connect with a custom error message
$mysql_link = @ mysql_connect ("$host:$port", $user, $pass)
    or die ("Could not connect to a MySQL server at '$host:$port' as user '$user'.");

echo "Connected to a MySQL server at '$host:$port' as user '$user'.";
?>

<?php
$sock = 'localhost:/var/lib/mysql/mysql.sock';
$user   = 'some_login';
$pass   = 'some_password';

// Handle connection errors gracefully
// Redirect the client to an error-handling page
$mysql_link = mysql_connect ($sock, $user, $pass)
    or header ('Location: http://www.example.com/mysql_connect_error.php');

echo "Connected to a MySQL server at $sock as user $user.";
?>