not connecting?

[Anon]

HI, I am not sure what is going on here...this is the first time I have made a php/mysql site. Everything worked fine loacally but i am having problems getting stuff into the database on the host server. I currently have a editing page that allows the user to update thier site with images and text and I am just using .htaccess as security for it.

Do I have to have a user and password or can I just use "localhost" on its own ? I have tried using the username/password that the host provided me with to connect to the mysql/php administration page but it seems to make no difference. As you can tell I am a complete nOOb so if someone can explain to me what could be going wrong here I would be really grateful.

Thanks in advance, Jeff

[Anon]

It depends on how your provider setup access. I usually setup a username and password for users and I use the machine host name instead of localhost.

My grant statements usually look like this ...

grant select, insert, update, delete on mytable.* to [e-mail] identified by 'password';

With this example, a mysql_connect woudl look like this ...

$connection = mysql_connect("my.host.com","username","password");