How can the error "Unknown MySQL server host 'localhost ' (11004)" be fixed in a PHP script using mysql_connect?

The error "Unknown MySQL server host 'localhost ' (11004)" indicates that there is an issue with the host name specified in the mysql_connect function. To fix this error, make sure that the host name is correct and does not contain any extra spaces or characters. Additionally, ensure that the MySQL server is running and accessible from the specified host. 

$host = 'localhost'; // Remove any extra spaces or characters
$username = 'username';
$password = 'password';
$database = 'database';

$connection = mysql_connect($host, $username, $password);

if (!$connection) {
    die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db($database, $connection);

if (!$db_selected) {
    die ('Can\'t use database: ' . mysql_error());
}

// Connection successful, proceed with database operations

Keywords

PHP mysql_connect MySQL server host localhost error 11004

Related Questions