将php脚本移动到godaddy服务器后，mysql查询一直失败

I've recently moved my php scripts and database online using godaddy. The queries all worked great before and I had no issues. I'm wondering if I missed something in initialization or something. Here is the php script that is failing. I've hidden my username and password for obvious reasons.

<?php
$servername = "localhost";
$username = "name";
$password = "password";
$dbName = "Rules";

$name = "billy";
$email = "billy@gmail.com";
$pass  = "1234";

//make a connection
$connection = new mysqli($servername, $username, $password, $dbName);

//Check the connection
if(!$connection)
{
    die("Connection Failed".mysqli_connect_error());
            echo "connection failed";
}

$sql = "INSERT INTO Users (username, email, password) VALUES('".$name."', '".$email."', '".$pass."')";
$result = mysqli_query($connection, $sql);

    if (!$result)
    {
        echo "query failed";
    }
?>

Here is the structure of the database