Ошибка подключения к бд cdbconnection failed to open the db connection

When i try connect to mysql with clear PHP, its working fine.
My code

$link = mysql_connect('hostname', 'username', 'password'); 
if (!$link) { 
      die('Could not connect'); 
} 
if(mysql_select_db('dbname')){
      echo 'Connected successfully'; 
}

But when im trying to connect with yii, then getting the error

My config/main.php

'db'=>array(
    'class'=>'CDbConnection',
    'connectionString' => 'mysql:host=hostname;dbname=dbname',
    'emulatePrepare' => true,  /* I try false too*/
    'username' => 'username',
    'password' => 'password',
    'charset' => 'utf8',
),

This is output for exception what i print in open() function framework/db/CDbConnection.php
Exception handle here

protected function open()
{
    if($this->_pdo===null)
    {
        if(empty($this->connectionString))
            throw new CDbException('CDbConnection.connectionString cannot be empty.');
        try
        {
            Yii::trace('Opening DB connection','system.db.CDbConnection');
            $this->_pdo=$this->createPdoInstance();
            $this->initConnection($this->_pdo);
            $this->_active=true;
        }
        catch(PDOException $e)
        {
        echo '<pre>';
        var_dump($e); die;
            if(YII_DEBUG)
            {
                throw new CDbException('CDbConnection failed to open the DB connection: '.
                    $e->getMessage(),(int)$e->getCode(),$e->errorInfo);
            }
            else
            {
                Yii::log($e->getMessage(),CLogger::LEVEL_ERROR,'exception.CDbException');
                throw new CDbException('CDbConnection failed to open the DB connection.',(int)$e->getCode(),$e->errorInfo);
            }
        }
    }
}

Exception text

"SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client"

I see in display

 CDbException

CDbConnection failed to open the DB connection.

My PHP VERSION 5.5.36 Mysql version 5.5.35
My Hosting is i-page dot com
Yii Version ‘1.1.13’
Thanks for help.

Ошибка «CDbConnection failed to open the DB connection.»

Модераторы: Xpycm, Koduc

Вернуться в Ошибки

Кто сейчас на конференции

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 1

Начал разбираться с Yii и пошли одни проблемы. При настройке gii в /index.php?r=gii/model/index выдал мне ошибку, мол CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1044] Access denied for user ‘fh7906mo_blog’@’localhost’ to database ‘testdrive’

В protected/config/main.php я написал подключение к БД

'db'=>array(
			'connectionString' => 'mysql:host=localhost;dbname=testdrive',
			'emulatePrepare' => true,
			'username' => 'fh7906mo_blog',
			'password' => '123456',
			'charset' => 'utf8',
			'tablePrefix' => 'tbl_',
		),

Я немного недопонимаю, почему доступ закрыт к базе данных, в чем может быть проблема?

В базе данных я создал таблицу tbl_user
Если я что-то не дописал, спрашивайте.

P.S Может это как-то связанно с файлом ‘testdrive’

I am trying to use the yii framework for a while. I have been referring — first-app-doc and yiic-doc.

I have read all the posts related to mine on «stackoverflow» but couldn’t get any luck resolving my problem. Mostly because I am stuck on the .ini files and the pdo.

I have modified the config file-protected/config/main.php according to my database configuration. I am using the command line tool — yiic to create the model. It gives me ‘http://hostname/path/to/index.php?r=user’ to hit.

When I hit http://localhost/index.php?r=user; it gives CDbException — CDbConnection failed to open the DB connection: could not find driver in the browser itself. It seems like it can’t find the pdo_mysql.
Also, I don’t have the php.ini file in /etc/php5/, but I have different php.ini files in /etc/php5/cgi/, /etc/php5/apache2/ and /etc/php5/cli/.

Also, the php5-mysql package, I have it installed on my computer.

I have been trying and trying. This is like impossible to do.