CODEWITHSUNDEEP
phpyii
temp-learn
temp-learn

Reputation: 537

Db Error while connecting with Yii Db settings

i am getting following error.

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

and this is my Db setting,now i am new to Yii so i dont know if there are some other things that i should mention, so if there are any other do let me know i will paste them ASAP.

// This is the configuration for yiic console application. // Any writable CConsoleApplication properties can be configured here.

return array(
    'basePath'=>dirname(__FILE__).DIRECTORY_SEPARATOR.'..',
    'name'=>'My Console Application',

    // preloading 'log' component
    'preload'=>array('log'),

    // application components
    'components'=>array(
//      'db'=>array(
//          'connectionString' => 'sqlite:'.dirname(__FILE__).'/../data/testdrive.db',
//      ),
        // uncomment the following to use a MySQL database

        'db'=>array(
            'connectionString' => 'mysql:host=localhost;dbname=mydb',
            'emulatePrepare' => true,
            'username' => 'root',
            'password' => '',
            'charset' => 'utf8',
        ),

        'log'=>array(
            'class'=>'CLogRouter',
            'routes'=>array(
                array(
                    'class'=>'CFileLogRoute',
                    'levels'=>'error, warning',
                ),
            ),
        ),
    ),
);

Upvotes: 1

Views: 1337

Answers (2)

Dude Lebowski
Dude Lebowski

Reputation: 159

I think mysql server is not running on your machine or the server you use.

Upvotes: 1

Nouphal.M
Nouphal.M

Reputation: 6344

I think you are missing the class:

'db'=>array(
            'class'=>'CDbConnection', // specify class 
            'connectionString' => 'mysql:host=localhost;dbname=mydb',
            'emulatePrepare' => true,
            'username' => 'root',
            'password' => '',
            'charset' => 'utf8',
        ),

Upvotes: 1

Related Questions