SQLSTATE[HY000] [1045] Access denied for user 'test'@'localhost' (using password: YES)

Question

I have install mariadb 10.2 on Digitalocean droplet. I have created test@localhost user and granted access to test database.

With test user I can able log into mysql console.

But when I am trying to connect to database from my Yii2 Application, access denied with password arises.

I have run mysql_secure_connection script to block root access from outside.

My DB Config -

Database Component Config:

return [
    'class' => 'yii\db\Connection', 
    'dsn' => 'mysql:host=localhost;dbname=test', 
    'username' => 'test', 
    'password' => 'test@123', 
    'charset' => 'utf8',
];

Does anyone has any idea.

where is your database component configuration add it to your question? — Muhammad Omer Aslam
– Muhammad Omer Aslam, Commented Apr 13, 2018 at 20:56
Database Component Config - return [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=test', 'username' => 'test', 'password' => 'test@123', 'charset' => 'utf8', ]; — user1184294
– user1184294, Commented Apr 14, 2018 at 4:05

pon prasath · Accepted Answer · 2020-11-04 13:18:43Z

1

use localhost:3306 instead of using host=local

answered Nov 4, 2020 at 13:18

pon prasath

111 bronze badge

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

Comments

Jairus · Accepted Answer · 2018-04-14 20:02:31Z

0

Try addin a new db user and use % for any host. See if you still are receiving the error. Attempt to connect to your DB via MySQL workbench, verify your credentials.

Did you deny remote access?

'db' => [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=localhost; dbname=somedb',
    'username' => 'root',
    'password' => 'passw0rd',
    'charset' => 'utf8',
]

edited Apr 14, 2018 at 20:02

answered Apr 14, 2018 at 19:42

Jairus

8568 silver badges28 bronze badges

Collectives™ on Stack Overflow

SQLSTATE[HY000] [1045] Access denied for user 'test'@'localhost' (using password: YES)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related