Failed to connected database its showing connection failedSQLSTATE[HY000] [1044] Access denied for user ''@'localhost' to database 'ecom'

Question

I have reinstalled wamp server and getting this error.Im using php pdo to connect with database here is my code

<?php 

 class Database{
      private $dbname="mysql:host=localhost; dbname=ecom;";
      private $dbuser="root";
      private $dbpass="";
      public $conn;

    public function __construct(){
        if(!isset($this->conn)){
            try {
                $this->conn= new PDO("$this->dbname,$this->dbuser,$this->dbpass");
                $this->conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
                
            } catch (PDOException $e) {
                die("connection failed".$e->getMessage());
            }
        }
     }
    

}

?>

score -1 · Answer 1 · answered Jul 16 '20 at 04:06

 <?php 

 class Database{
      private $dbname="mysql:host=localhost; dbname=ecom;";
      private $dbuser="root";
      private $dbpass="";
      public $conn;

    public function __construct(){
        if(!isset($this->conn)){
            try {
                $this->conn= new PDO($this->dbname,$this->dbuser,$this->dbpass);
                $this->conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
                
            } catch (PDOException $e) {
                die("connection failed".$e->getMessage());
            }
        }
     }
    

}

?>

Failed to connected database its showing connection failedSQLSTATE[HY000] [1044] Access denied for user ''@'localhost' to database 'ecom'

1 Answers1