injetkilo injetkilo - 1 year ago 152
PHP Question

SQLSTATE[28000] [1045] : Strange PDO error after server provider crash

After a crash server, we have a strange error with our database...

Password and user is correct, we use a simple PDO connect :

ini_set('display_errors', 1);
ini_set('log_errors', 1);
$bdd = new PDO('mysql:host=localhost;dbname=databaseName', 'correctUSER','correctPassword');
catch(Exception $e)`enter code here`
die('Erreur : '.$e->getMessage());

But we have a : "Error : SQLSTATE[28000] [1045] Access denied for user 'correctUSER'@'localhost' (using password: YES)" ??

We try to delete, recreate database and user but we have always the problem, the strange thing is that if we try we the root user => it works but it's not safe to use the root password...

Anyone have a solution ??

Thanks !

Answer Source

It was an error with mysql, I have to make a

REPAIR TABLE mysql.user

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download