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";
?>
Latest posts by rajeshkumar (see all)
- PHP Error: Warning: mysqli::__construct(): (HY000/1044): Access denied for user - October 25, 2022
- WordPress Error: llegal mix of collations - October 14, 2022
- Vault Error: dpkg-deb: error: paste subprocess was killed by signal - October 12, 2022