我在使用 pdo 連接到 Sql Workbench 時遇到問題。顯示以下錯誤，盡管我已經嘗試了各種連接方式。收到錯誤：SQLSTATE [HY000] [1045] 用戶'root'@'localhost'的訪問被拒絕（使用密碼：否）<?phpsession_start();try {$con = new PDO ("mysql:host=localhost;dbname=users",'root','');if(isset($_POST['signup'])){ $username = $_POST['username']; $email = $_POST['email']; $password = $_POST['password']; $fname = $_POST['fname']; $lname = $_POST['lname']; $city = $_POST['city']; $insert = $con->prepare("INSERT INTO users1(username,email,password,fname,lname,city) values(:username, :email, :password, :fname, :lname, :city) "); $insert->bindParam (':username',$username); $insert->bindParam (':email',$email); $insert->bindParam (':password',$password); $insert->bindParam (':fname',$fname); $insert->bindParam (':lname',$lname); $insert->bindParam (':city',$city); $insert->execute();}elseif (isset($_POST['signin'])){ $username = $_POST['username']; $password = $_POST['password']; $select = $con->prepare("SELECT*FROM users1 where username='$username' and password='$password'"); $select->setFetchMode(PDO::FETCH_ASSOC); $select->execute(); $data=$select->fetch(); if($data['username']!=$username and $data['password']!=$password) { echo "Invalid username or Password"; } elseif($data['username']==$username and $data['password']==$password) { $_SESSION['username']=$data['username']; $_SESSION['email']=$data['email']; $_SESSION['fname']=$data['fname']; $_SESSION['lname']=$data['lname']; header("location:profile.php"); } }}catch (PDOException $e) { echo "Error: ". $e -> getMessage();}?>
2 回答
江戶川亂折騰
TA貢獻1851條經驗 獲得超5個贊
如果您不知道密碼，可以使用以下命令更新密碼：
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
//then connection will be:
$con = new PDO ("mysql:host=localhost;dbname=users",'root','MyNewPass');
藍山帝景
TA貢獻1843條經驗 獲得超7個贊
我認為它要求輸入密碼
$con = new PDO ("mysql:host=localhost;dbname=users",'root','your_password');- 2 回答
- 0 關注
- 130 瀏覽
添加回答
舉報
0/150
提交
取消