Hi!I tried to connect a PHP script to a database(called eu).I checked all privileges for user root,the one I use in PHP ,but I get this error:"Array ( [0] => Array ( [errno] => 1044 [sqlstate] => 42000 [error] => Access denied for user ''@'localhost' to database 'eu' ) ) 1".Please help!
Code:<?php
/* db.php contains these $dbname = "eu";
$dbusername = "root";
$dbpassword = "";
$dbsrvname = "localhost";*/
include('..\db.php');
$con = mysqli_connect($dbsrvname, $dbusername, $dbpassword, $dbname);
if (!$con){
echo('Connection ERROR');
die(print_r(mysqli_error($con)));
}
$query="USE eu";
$stms=mysqli_query($con,$query);
$x=$_POST['username'];
$y=$_POST['password'];
if ($stms === false){
echo('ERROR during query execution: ');
die(print_r($con->error_list));
}
$row = mysqli_fetch_array($stms, MYSQLI_ASSOC);
if ($row){
die('Logged in');
}
else{
die('Wrong username or password');
}
?>