How To Connect Port Mysql ?

Yii 1.1 General Discussion
1

hi all…

i use sphinx server as database.

my sphinx connection is using port : 9306

in this page : http://www.yiiframework.com/doc/guide/1.1/en/database.dao explain about creating connection…

my qusetion " how to add port from this code " ?




array(

    ......

    'components'=>array(

        ......

        'db'=>array(

            'class'=>'CDbConnection',

            'connectionString'=>'mysql:host=localhost;dbname=testdb',

            'username'=>'root',

            'password'=>'password',

            'emulatePrepare'=>true,  // needed by some MySQL installations

        ),

    ),

)
2

Just add port=9306 to connectionString, e.g:




   		'connectionString'=>'mysql:host=localhost;port=9306;dbname=testdb',
3

Thanks sharma…

i will try…