easy question.. im just lame

Anon

how do i manually change the host that are allowed to connect to the database ? i cant connect, it keeps telling me that the host isnt allowed to connect to the database. i have the real real hostname (server) in the database with the user that i want, but i want to connect from the host (www) to the database (server) and it says host (www) isnt allowed to connect to the server. how do i fix this ? thanks for your help.

zhabala

You have to tell us which DB you are using. Then we can try to help.

Anon

MySQL permission statements look like this:

grant (select,delete,all,etc) on db.table to user@hostname identified by 'password';

mithril

Are you entering something like "www.hostname.com" as the host to connect to? If so, try changing that to "localhost". Most providers don't allow external access to their database servers. HTH.

-geoff

Anon

Are you sure that the Server to which you are trying connection is accessble?

Assuming that the database you are using is Developed using MYSQL:

$connect = mysql_connect("localhost","","");

but if the server is like www.xxx.yyy, then
you should enter as follows:

$connect = mysql_connect("www.xxx.yyy", "username", "password");

May be if you are using phpMyAdmin, try to change the server, username, an password to the one you are going to connect in config.inc.php file,

bye...