PHP Error: Warning: mysqli::__construct(): (HY000/1044): Access denied for user

Post Views: 29

Error

Warning: mysqli::__construct(): (HY000/1044): Access denied for user

Solution

Password must be in SINGLE quote instead of Double QUOTE

Example Code – 1

<?php
function OpenCon()
 {
 $dbhost = "localhost";
 $dbuser = "testuser";
 $dbpass = 'GHSJ$D47687';
 $db = "vijayji";
 $conn = new mysqli($dbhost, $dbuser, $dbpass, $db) or die("Connect failed: %s\n". $conn -> error);

 return $conn;
 }

function CloseCon($conn)
 {
 $conn -> close();
}

$conn = OpenCon();
CloseCon($conn);

Example Code – 2

<?php
$servername = "localhost";
$username = "username";

// PASSWORD MUST BE IN SINGLE QUOTE
$password = 'password';

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

Author
Recent Posts

rajeshkumar