上传 Yii 网站在线时出错


Error When upload Yii Website for online

当我将我的Yii网站上传到idwebhost时,我遇到了这样的问题

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1045] Access denied for user 'cieprod1_ubay'@'ngasem.idwebhost.com' (using password: YES) 

我在main.php中的配置:

'db'=> array(
        'connectionString' => 'mysql:host=cieproduction.com;dbname=cieprod1_dbmabak',
        'emulatePrepare' => true,
        'username' => 'cieprod1_ubay',
        'password' => 'XXXXXXXX',
        'charset' => 'utf8',
        ....
    );

我不知道出了什么问题:(

尝试host=localhosthost=127.0.0.1而不是cieproduction.com

实际上,您的MySQL数据库主机 cieproduction.com,并且您正在尝试从 ngasem.idwebhost.com 访问。因此,您应该授予来自主机 ngasem.idwebhost.com 的用户cieprod1_ubay访问数据库cieprod1_dbmabak的权限。MySQL服务器上的此用户"呈现"为cieprod1_ubay@ngasem.idwebhost.com。MySQL 授权查询如下所示:

grant all on cieprod1_dbmabak.* to `cieprod1_ubay`@`ngasem.idwebhost.com`;

或者尝试联系托管管理员来帮助您。

试试这个

'db'=> array(
        'connectionString' => 'mysql:host=localhost;dbname=cieprod1_dbmabak',
        'emulatePrepare' => true,
        'username' => 'cieprod1_ubay',
        'password' => 'XXXXXXXX',
        'charset' => 'utf8',
        ....
    );