Problem connecting to MySQL with PEAR::DB and mysqli
| From: | markusjais at gmx dot de | Date: | Thu, 17 Feb 2005 08:47:13 +0000 |
| Subject: | Problem connecting to MySQL with PEAR::DB and mysqli | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-208901@lists.php.net to get a copy of this message | ||
hello
when connecting to MySQL 4.1 using PHP 5 and PEAR::DB I get this error:
DB Error: connect failed
a closer look gets this:
Can't connect to local MySQL server through socket 'localhost' (2)
the code for the connection is like this::
========
public static function getConnection() {
$mysql_user = "myname";
$mysql_password = "secret";
$mysql_host = "localhost";
$db_name = "mydb";
$dsn = "mysqli://$mysql_user:$mysql_password@$mysql_host/$db_name";
echo $dsn;
$db = DB::connect($dsn);
if(DB::isError($db)) {
echo $db->getMessage();
}
return $db;
}
=======
the DSN looks correct:
and in the php.ini I set the following option:
mysqli.default_socket = /var/lib/mysql/mysql.sock
this is where the socket for mysql access is.
then I restarted apache and mysqld.
the MySQL Server is running. I can connect via mysql on the command line
but not with PEAR::DB.
I am using PHP 5, the latest PEAR::DB, Apache 1.3 on a Redhat 7.3 System.
any ideas what's wrong here ?
Markus