Posted by Denis Gerasimov on 02/18/05 17:23

Hello,

I suspect that all is OK in your code. I had a very similar problem three
days ago. Try connecting to FQDN like user@example.com via TCP/IP, not to
localhost via UNIX socket. It works in my case at least.

BTW it seems to be a DB package bug... write a simple test script with
mysqli_* functions and look if it will work.

And, of course, check MySQL user priviliges/hosts twice!

Best regards, Denis Gerasimov
Outsourcing Services Manager,
VEKOS, Ltd.
www.vekos.ru


> -----Original Message-----
> From: markusjais@gmx.de [mailto:markusjais@gmx.de]
> Sent: Thursday, February 17, 2005 11:47 AM
> To: php-general@lists.php.net
> Subject: [PHP] Problem connecting to MySQL with PEAR::DB and mysqli
>
> 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

[Back to original message]