PHP Login script failing to connect PLEASE HELP

Hi All. I am new to PHP and have slowly created a PHP login script however it is failing to connect. Please can someone advise. I am using a freenas hosting apache and using phpmyadmin.

The error i am getting is

“Warning: mysqli_connect(): (HY000/1130): Host ‘HostServer’ is not allowed to connect to this MySQL server in /usr/local/www/apache24/data/php/login.php on line 9
Database connection failed!Host ‘HostServer’ is not allowed to connect to this MySQL server”

[code=php]

$cookie_name = “loggedin”;

$servername = “192.168.0.2”;
$username = “root”;
$password = “XXXXXXXXXXXXXXX”;
$database = “homedb”;

$conn = mysqli_connect($servername, $username, $password, $database);

if (!$conn) {
die(“Database connection failed!”.mysqli_connect_error());
}

if (isset($_POST[‘login’]))
{
$user = $_POST[‘username’];
$pass = $_POST[‘password’];

$phash = sha1(sha1($pass.”salt”).”salt”);
$sql = “SELECT * FROM users WHERE username=’$user’ AND password=’$phash’;”;

$result = mysqli_query($conn, $sql);
$count = mysqli_num_rows($result);

if ($count == 1)
{
$cookie_value = $user;
setcookie($cookie_name, $cookie_value, time() + (180), “/”);
header(“Location: homepage.php”);
}

Else
{
echo “Username or Password is incorrect!”;
}
}

else if (isset($_POST[‘register’]))
{
$user = $_POST[‘username’];
$pass = $_POST[‘password’];

$phash = sha1(sha1($pass.”salt”).”salt”);
$sql = “INSERT INTO users (id, username, password) VALUES (”, ‘$user’, ‘$phash’);”;

$result = mysqli_query($conn, $sql);

}
[/code]

Also in #PHP _↴