How To Fix CDbConnection failed to open the DB connection could not find driver on Yii Mysql

•  Make sure  your PHP engine location path in system variable.
•  Make sure you active php_pdo_mysql on php.ini

If your error in web

Uncomment the following to use a MySQL database on protection/config/main.php

                               

'db'=>array(

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

'emulatePrepare' => true,

'username' => 'root',

'password' => 'your pass',

'charset' => 'utf8',

),

                If your error in console

                 Uncomment the following to use a MySQL database protection/config/console.php     

'db'=>array(

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

'emulatePrepare' => true,

'username' => 'root',

'password' => 'your pass',

'charset' => 'utf8',

),

 You can change host with 127.0.0.1 

Have Nice Day

                

Read More

Step by Step Install Yii on Wamp, Xampp

Step 1: Assigning PHP engine location path in system variable

• Go to “My Computer” ->Right click and select "Properties"
• Click "Advanced system settings" from left pane
• Under "Advanced" tab click on "Environment Variables"
• Under "System variables" scroll down and find text "Path" then Double click on it
• Now enter your PHP engine location on end of the "variable value" field
• i.e. for wamp entered "C:\wamp\bin\php\php5" or for xampp "C:\xampp\php". Just enter location without double quotes
• Click ok and finally exit from this.

Step 2: Create new folder under your web root folder i.e "testyii"

Step 3: Download yii framework and extrack under web root folder

• Go "http://www.yiiframework.com/" and download latest Yii framework zipped file
• Unzip and rename folder to "yii"
• Using command-
• C:\web root>cd yii\framework\
• C:\web root \yii\framework>yiic webapp C:\web root\testyii
• Create a Web application under ‘C:\wamp\www\bid’? [Yes|No] y
• Your application has been created successfully under C:\web root\testyii.

Now you are ready to browse your project by accessing the URL : http://localhost/testyii/

Read More