connect to my my sql data base help plez

[mohamedfiky]

i have account on hostmonister sicc-kagoshima.org , i created the data base by phpmyadmin ,

i have form and i connected the form with my local host in my local server and the php code is ok but when i imegrate the connection to be to the remote server i had connection error

so i think the problem is that hostname is wrong

could u please tell me whcih hostname i have to use ??

the password is for the database or the server ????

do i have to contact support team for firewall settings ??

[shadmego]

could u please tell me whcih hostname i have to use ??
You can either use the IP address of your domain name or the actual domain name. I would recommend your domain name as the IP address might change. It's unlikely it will, but it could ...


]
the password is for the database or the server ????
the database



do i have to contact support team for firewall settings ??
This will probably be your best bet. There is a way you can open the database firewall yourself, but you can only enter the IP address of the computer with which you are logged into your HM account. Support *might* be able to add other addresses for you, but I'm not sure about that .... which is why I repeat my first statement .... it would probably be best to contact them for the firewall settings ...

[malefic]

I think hostname is the hostname of the database server, try using localhost for the name.

http://imgs.theimagesafe.info/cheers.gif Cheers
M.

[Kobeer]

Yeah, localhost would be the hostname to use if you're connecting from the script ON THE SERVER to the database ON THE SERVER.

If you're connecting from the outside into the server, the server IP address works well, and on top of that, make sure you get the location you're connecting from whitelisted.

If you're just whitelisting the location you're at, just go into cpanel, update billing, then look at the customer preferences.

If you need to whitelist an IP for a location you're not currently located at, contact support, and they can get it added for you.

[Mitch1234]

I agree with Kobeer.

you need to be white listed on server and database remote access hosts will also need you IP.

So there are two areas you need your IP.

I am working on a workaround for my self with a servlet, but I still have alot to learn