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

Question

I'm actually making a form in PHP with MVC2. In my model, I need to connect to a local MySQL database. I do this with PDO. Here is my dsn :

mysql:host=localhost;dbname=test-heia;charset=utf8mb4', "test", "test"

But when I try to access my model through Chrome, I got this error (with PDOException) :

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

I'm sure of the user/password. I also tried with root user, but it doesn't seems to work.

It's not like the proposed answer, because it's on a web page :)

Could you please help me ? Thank you in advance :)

You should update your title since it isn't the same error message as in your question. — M. Eriksson
– M. Eriksson, Commented Apr 10, 2019 at 14:39
Can you access the database with the same user/pass via the command line? — aynber
– aynber, Commented Apr 10, 2019 at 14:52

LeRouteur · Accepted Answer · 2019-04-11 06:58:26Z

1

I resolved the problem. The path to the socket of MySQL wasn't enabled (see here). Once I put it, it worked.

Thank's all for the answers ! :)

answered Apr 11, 2019 at 6:58

LeRouteur

1451 gold badge2 silver badges13 bronze badges

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

Comments

paki leonel · Accepted Answer · 2019-04-10 14:44:24Z

0

define('DBHOST', 'localhost');
define('DBUSER', 'test');
define('DBPASS', 'test');
define('DBNAME', 'test');

try {
    $bd= new PDO('mysql:host='.DBHOST.';dbname='.DBNAME,DBUSER,DBPASS);
}catch(Exception $e)
 {
    die('Erreur : '.$e->getMessage());
 }

Try it with that

answered Apr 10, 2019 at 14:44

paki leonel

12 bronze badges

4 Comments

aynber Over a year ago

There's no real difference between your code and the OP's code.

paki leonel Over a year ago

There is no difference, because he said he wanted to connect PDO and what I did is pdo.

LeRouteur Over a year ago

Ty, Il try this tomorrow :)

Joel Hernandez Over a year ago

Works like magic, thanks for the tip. I had the same issue with different production servers...

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related