Problem with connection to DB

harvey · #1 (**permalink**) 04-11-2007, 02:22 PM

Hi, can somebody help me with this problem? I am trying to connect to MySql DB like this :

PHP Code:


			
$params = array ('host' => ':/tmp/mysql50.sock',

                         'username' => 'my_username',

                         'password' => 'my_pass'

                         'dbname'   => 'my_db_name');



$db = Zend_Db::factory('PDO_MYSQL', $params);

And apache returns exeption like this :

Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2005] Unknown MySQL server host ':/tmp/mysql50.sock' (3)' in my_path/lib/Zend/Db/Adapter/Pdo/Abstract.php:102 Stack trace: #0 my_path/lib/Zend/Db/Adapter/Abstract.php(143): Zend_Db_Adapter_Pdo_Abstract->_connect() #1

some other stuff

thrown in my_path/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 102

connection using mysql_connect() works OK.
Where should be problem? thanks for all answers.

Cristian · #2 (**permalink**) 04-11-2007, 05:52 PM

You forgot to add host to your connection.

If you are connecting to a local database server then using localhost for host parameter is just fine.

harvey · #3 (**permalink**) 04-13-2007, 09:37 AM

I solved this problem, I've done it like this:

PHP Code:


			
$params = array ('unix_socket' => ':/tmp/mysql50.sock',
                                     'username' => 'my_username',
                                     'password' => 'my_pass'
                                     'dbname'   => 'my_db_name');

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode