Db Error while connecting with Yii Db settings

Question

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',
                ),
            ),
        ),
    ),
);

Do you have MySQL installed on your localhost? Is it running? (The file you posted is the configuration for running Yii in the console/command prompt. The configuration for the Yii web app is typically in main.php.) — user1233508
– user1233508, Commented Feb 15, 2014 at 14:55

Nouphal.M · Accepted Answer · 2014-02-15 14:50:04Z

1

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',
        ),

answered Feb 15, 2014 at 14:50

Nouphal.M

6,3281 gold badge20 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nouphal.M Over a year ago

Also where is your code placed? i believe its under protected/config/main.php

temp-learn Over a year ago

ah, i think i found what is missing that file is hitting some remote db all the time iw as looking for some other file named config.php

Dude Lebowski · Accepted Answer · 2014-02-15 14:56:18Z

1

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

answered Feb 15, 2014 at 14:56

Dude Lebowski

1591 silver badge10 bronze badges

3 Comments

temp-learn Over a year ago

hmm, and how to test if i am running a remote server?

temp-learn Over a year ago

i am connected VIA Xammpp on local and other apps are running fine, but this isnt

Dude Lebowski Over a year ago

I seems that mysql is not started on your localhost. I don't use XAMPP but I know it has a control panel where you can see all processes that are running or not.

Collectives™ on Stack Overflow

Db Error while connecting with Yii Db settings

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related