如何从我的localhost连接到我的数据库sql文件？

Question

I am trying to connect to my database through php. I exported my php database as an sql file as told. I tried to go to connect to it and show a message that i am connect. However I'm not.

Im running my php in netbeans and the file is located in wamp > www

it says ERROR: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

<?php
try {
$conn = new 
PDO('mysql:host=localhost;dbname=isad235', "root", 
"root");
echo "CONNECTED";
$sql = "SELECT * FROM members";
foreach($conn->query($sql) as $row)
{
  echo $row;
}
}catch(PDOException $e)
{
 echo 'ERROR: '.$e->getMessage();
}
?>

Answer 1

this is working for me. It it doesnt work you need to check your credentials.

class db {
    public static function dbFactory($host, $dbase, $user, $pass) {
        $pdo = new PDO("mysql:host=$host;dbname=$dbase", $user, $pass);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);        
        return $pdo;
    }
}
$db = db::dbFactory('localhost','mydbname','myusername','mypassword');

by the way, you cannot connect to an sql file. You need to import it into your dbms. After that you should be able to connect.