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)