Kód: Vybrať všetko

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1044] Access denied for user ''@'localhost' to database 'projectdb'' in C:\xampp\htdocs\test.php:2 Stack trace: #0 C:\xampp\htdocs\test.php(2): PDO->__construct('mysql:host=loca...', 'mndentdb') #1 {main} thrown in C:\xampp\htdocs\test.php on line 2

Kód: Vybrať všetko

<?php
$dbh = new PDO('mysql:host=localhost;dbname=projectdb', 'projectdb', 'tajneHeslo');
?>

Kód: Vybrať všetko

CREATE USER 'projectdb'@'localhost' IDENTIFIED WITH mysql_native_password BY 'tajneHeslo';
GRANT USAGE ON *.* TO 'projectdb'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
REVOKE ALL PRIVILEGES ON *.* FROM 'projectdb'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'projectdb'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QU.....