MySQL Error, Useless web host

[Austen]

Well, I'm attempting to make a connection to my database, and I've never had this error before so I don't know how to deal with it, and my webhost says my phpmyadmin is working, and don't understand that that's not the problem D:


Warning: mysql_connect() [function.mysql-connect]: Host 'srv11.000webhost.com' is not allowed to connect to this MySQL server in /home/a9448809/public_html/shoutboxtemplate.php on line 108



D: Any help?

[Charles Stover]

Can you post the mysql_connect() line of your code (taking out your password, of course)?

If I'm not mistaken, 000webhost tells you your MySQL information in a sidebar in the admin CP.

You will need either:
mysql_connect('localhost', 'etc', 'etc');

Or:
mysql_connect('what is in the admin cp', 'etc', 'etc');

I think they use a subdomain for their MySQL server instead of just using localhost. You pretty much just have to copy-paste it from their sidebar.

[Austen]

mysql_connect("mysql_host", "$mysql_user", "$mysql_password") or die(mysql_error());
mysql_select_db("$mysql_database") or die(mysql_error());

I have the details COPIED from the Control Panel so it can't be wrong.

LOL! I'm pretty stupid ... Forgot the $ D:

[Austen]

I fixed that error, now I'm getting

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a9448809'@'localhost' (using password: NO) in /home/a9448809/public_html/shoutboxtemplate.php on line 108

Access denied for user 'a9448809'@'localhost' (using password: NO)

[Charles Stover]

When I asked for mysql_connect, I mostly wanted to see the MySQL host to see if it was localhost or a subdomain. But oh well, you got that fixed.

Your problem now is that you don't have the MySQL password entered.

[Bennett 🚀]

Jul 18, 2011 7:55:15 GMT -8 Charles Stover said:

When I asked for mysql_connect, I mostly wanted to see the MySQL host to see if it was localhost or a subdomain. But oh well, you got that fixed.

Your problem now is that you don't have the MySQL password entered.

This, or you haven't created the user yet.

[Snakeair]

000webhost is a bad host to have. I once had a wordpress plugin that broke one of my tables in mysql and instead of me fixing it because i was lazy that day, i contact hostgator live support tech and in 5 minutes it was fixed and i found out the 2 plugins that was not compatiable.

Sometimes ones website/blog out grow's a host or there shared hosting packages. If i get bad support from a host a few times then i change hosts.

Sorry i took the thread offtopic a little.