yiic: CDbConnection failed to open the DB connection

Question

My DB connection works perfectly in web application. But when I try the same settings in console application it fails (I wrote connection settings in console.php file).

CDbConnection failed to open the DB connection: SQLSTATE[28000] [1045] Access denied for user 'username'@'host' (using password: YES)

I can't solve problem for 4 hours. What might be wrong?

if show showed us what both your `main.php` and `console.php` look like.. — Developerium, Mar 11 '14 at 12:05

score 0 · Answer 1 · answered Mar 16 '14 at 12:56

0

In console.php change localhost to 127.0.0.1

answered Mar 16 '14 at 12:56

Chalist

3,160
5
39
68

score 0 · Accepted Answer · answered Jul 07 '14 at 05:32

0

if you want to connect to the same DB which you connect to in your web application then copy your 'db' => array(...) in config/main.php to config/console.php

answered Jul 07 '14 at 05:32

Krupal Solanki

36
5

yiic: CDbConnection failed to open the DB connection

2 Answers2