I tried Install drupal In my hosting service but I'm totally stuck and have not a clue what I did wrong

first, drupal worked properly when used in localhost


sites/default/setting.php

$db_url='mysql://myusername:mypassword@localhost/mydatabase';



Than I change it to my host;

sites/default/setting

$db_url='mysql://myusername:mypassword@db5.mysites.com/mydatabase';

but when I tried to open, It shows Internal server error

what have I done wrong?????
can you tell me the right setting????
please help me!!!



regards,
gippal

Do you have a database on that other server ?
And the server with the database have to support requests from the outside.

Its easy to have the hosting and the database on the same server, then you have no problems.

Sure I have a username and a database in that server....but the location on my database is different with my domain and subdomain.

for example my subdomain is http://gippal.finalFantasy.com
but my database located in db5.finalFantasy.com

in my host, it automaticvally host database in separated location
is drupal can't open mysql database that has separated location????




regards,

gippal

Never tried it before on a other location.

I'm running drupal on a local server (lampp), and the database and the webserver are on the same computer.

Note: You have to make a database and (database)user on the server before you can start.
Then you have to make the tables with the SQL provided with the instalation.

With my configuration it worked in a few minutes.
I'll try to move the database to another computer in my (small) LAN and I'll see what happens.

I have tested the following and it works :

Webserver (in local lan using XAMPP).
Database (on free server http://www.freesql.org)

The line in the drupal config becomes :



Note the Italic has to be filled in with your specs.
The number :3306 is port on the server that's listening for database access.
(you need to specify this when it's not the default port).