CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) YII2 in local

Question

So I just downloaded yii2 project from server using Winscp to run it in my local, but when I run it gives me the error: CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO). I've checked the user privileges and I've grant all privileges. (user table mysql).

Here's the main.php:

'db'=>array(
        'connectionString' => 'mysql:host=127.0.0.1;dbname=serena',
        'emulatePrepare' => true,
        'username' => 'root',
        'password' => '',
        'charset' => 'utf8',
    ),

using password: NO ? (First off, please set a password for root for security, and please create a separate mysql user account with password and necessary privileges for accessing the db) — Ken Lee
– Ken Lee, Commented Feb 8, 2023 at 3:04
still gives me error. Access denied for user 'tommy'@'localhost' (using password: YES) — sanxerta
– sanxerta, Commented Feb 8, 2023 at 3:11
Does this answer your question? SQLSTATE[HY000] [1045] Access denied for user 'test'@'localhost' (using password: YES) — vishuB
– vishuB, Commented Feb 9, 2023 at 10:34

sanxerta · Accepted Answer · 2023-02-09 11:30:37Z

0

I just adding the port because I have different port.

 'connectionString' => 'mysql:host=127.0.0.1;dbname=serena;port=8111',

answered Feb 9, 2023 at 11:30

sanxerta

234 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) YII2 in local

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related