28.4.1 Connecting to the MySQL Database

Always check:

if (mysql_real_connect(...) == NULL)
{
   string error_message = mysql_error(connection);
   . . .
}

When done, free resources in your program and in the DB:
mysql_close(connection);