Can't connect to MySQL DB

[codegee3]

Hi,
I am in the process of bringing my website out of development (off of my localhost) and onto a web host. I setup the database, uploaded my PHP files, and modified my connection.php file (which is where I connect to the DB) with the correct information for the newly created DB. However, when I go to my site, I get an error:

Warning: mysqli_connect(): (42000/1044): Access denied for user 'codegee3_luigi'@'198.91.81.7' to database ' codegee3_codegeek' in /home/codegee3/public_html/connect.php on line 9

Connection failed: Access denied for user 'codegee3_luigi'@'198.91.81.7' to database ' codegee3_codegeek'

 

[codegee3]

Also, here is my connect.php file:

<?php
/**
* Created by PhpStorm.
* User: Luigi Battaglioli
* Date: 6/27/2017
* Time: 4:55 PM
*/
$username = 'codegee3_luigi';
$password = 'my password';
$database = 'codegee3_codegeek';
$host = 'codegeek.pcriot.com';

// Create connection
$conn = mysqli_connect($host, $username, $password, $database);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

 

[bdistler]

x10hosting's free-hosting database SQL_HOST name --> [ localhost ]

try --> [ $host = 'localhost'; ] - without the brackets
###

 

[codegee3]

x10hosting's free-hosting database SQL_HOST name --> [ localhost ]

try --> [ $host = 'localhost'; ] - without the brackets
###

Hmmm, now it just says:

Warning: mysqli_connect(): (42000/1044): Access denied for user 'codegee3_luigi'@'localhost' to database ' codegee3_codegeek' in /home/codegee3/public_html/connect.php on line 9
Connection failed: Access denied for user 'codegee3_luigi'@'localhost' to database ' codegee3_codegeek'

 

[bdistler]

I 'see' a space after first quote in [ to database ' codegee3_codegeek' ]
###

 

[codegee3]

I 'see' a space after first quote in [ to database ' codegee3_codegeek' ]
###

AHHHHH! Thank you so much! This was driving me insane trying to figure it out. It works now! You da bomb!