MySQL access denied...

[jbdesign]

No matter what I do I keep getting this error.

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'jbdesign'@'localhost' (using password: NO) in /home/jbdesign/public_html/test_connect.php on line 3
Couldn't connect to server.

I am using a remote file to assign the account information to variables in the following format:

$host = "localhost";
$user = "jbdesign_userIDthatIchose";
$password = "passwordthatisfortheuser";
$dbname = "jbdesign_databasename";

I did a quick search and kept finding stuff like "Due to abuse on the free accounts remote access to the databases is disabled.", is this true? If so is there anyway I can gain remote access to MySQL?

Any help would be appreciated.

 

[garrettroyce]

No. Remote access is denied by the server firewall. All incoming requests on port 3306 (mysql) will be blocked.

I think you have a different problem though. If you are using localhost as the server, you are saying that mysql and the file are on the same server, which is not blocked. The error message states: using password: NO, which may be your problem. Double check that the password variable is being used correctly and is set before you pass it to the connect function.

 

[jbdesign]

I feel so stupid... found a space " " in front of the user name.

Thanks for the help!

 

[garrettroyce]

No problem