ID: 39672 Updated by: [EMAIL PROTECTED] Reported By: acct dot php at povpromotions dot com -Status: Open +Status: Bogus Bug Type: PDO related Operating System: apache PHP Version: 5.2.0 New Comment:
http://www.php.net/manual/en/ref.pdo-mysql.connection.php The PDO_MYSQL Data Source Name (DSN) is composed of the following elements: <.....> unix_socket The MySQL unix socket (shouldn't be used with host or port). Previous Comments: ------------------------------------------------------------------------ [2006-11-29 00:59:27] acct dot php at povpromotions dot com Description: ------------ My ISP has implemented both MySQL4 and MySQL5. Because of this, I have to connect to the MySQL5 database using a socket port on the connect: localhost:/tmp/mysql5.sock However, PDO fails to connect when I use this. I have tried both: $dbH = new PDO('mysql:host=localhost:/tmp/mysql5.sock;dbname='.DBASE, DBUSER, DBPWORD ); $dbH = new PDO('mysql:host=localhost;port=/tmp/mysql5.sock;dbname='.DBASE, DBUSER, DBPWORD ); The first returns this error: Exception message: SQLSTATE[HY000] [2005] Unknown MySQL server host 'localhost:/tmp/mysql5.sock' The second returns this error: SQLSTATE[00000] [1044] Access denied for user: '[EMAIL PROTECTED]' to database '*****' which means it is pointing to the old MySQL4 db and is not using the port. I use many other connection methods that work fine with host="localhost:/tmp/mysql5.sock" Any help would be appreciated. dbrucas ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39672&edit=1
