CDbConnection failed to open the DB connection: could not find driver in Yii

php mysql yii zend-studio yii-cactiverecord
user2853731 picture user2853731 · Dec 5, 2013 · Viewed 46.2k times · Source

while trying to connect with mysql in yii framework it shows

"CDbConnection failed to open the DB connection: could not find driver " error

php code :

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

my php drivers are already enabled , but it shows the same error

Im using zend studio, zend server for this

how could i fix this?

Answer

ackuser picture ackuser · Aug 20, 2014

I am using Linux Mint..In my case I needed 

apt-get install php5-mysql

because I was moving my environment from Lampp to Apache + PHP + MySQL and I had to change a lot of things in the php.ini

Related questions

Yii2 How to perform where AND or OR condition grouping?

I am new to Yii-2 framework. How can i achieve following query in Yii-2 framework using activeQuery and models. SELECT * FROM users AS u WHERE u.user_id IN(1,5,8) AND (u.status = 1 OR u.verified = 1) OR (u.social_account = 1 AND …

Read More
"Invalid parameter number: parameter was not defined" Inserting data

UPDATE I was making a petty mistake when listing the VALUES. I should have put ":username" and not ":alias". I suppose the answer credit to this question is free reign for anyone who wants it? Or do I delete the …

Read More
Yii INSERT ... ON DUPLICATE UPDATE

I am working on a Yii project. How can I use the ON DUPLICATE feature of MySQL ( http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html ) when doing a save() on a Yii model? My MySQL is as follows: CREATE …

Read More