MySQL Url

[iGuest 3]

always I have to use localhost? or there is a URL for mysql?

[vujsa 0]

always I have to use localhost? or there is a URL for mysql?

1064323833[/snapback]

You can still use "localhost" on your websites here unless you are trying to access it remotely which may not be possible. The remote permissions have probably been set to disallow.

 

I always just use "localhost" as IP addresses can change but "localhost" will always be where your script is. Therefore, I reccomend continueing to use "localhost" as the location of your MySQL server.

 

I wouldn't even know where to begin to specify the location of the MySQL server on the hosting server as there are many accounts on there. I think that the MySQL server location is probably 69.50.168.69 currently to answer your question though.

 

Hope this helps.

 

vujsa

[TheJeffsta 0]

As far as i know, you dont need to always use 'localhost', its just the easier and more desired. Obviously if you were really advanced you would be able to do it the other way by putting the IP address or the URL.For people that don't have much experience or knowledge about the webserver for the MySQL databases, then i would suggest leaving it at 'localhost'.

[Hercco 0]

Localhost = 127.0.0.1 So in fact to connect to a database you always need to use the address. It just happens to be that the database server is located behind the same IP address and thus localhost, which means the address 127.0.0.1, can be used.

[minnieadkins 0]

Localhost = 127.0.0.1

 

So in fact to connect to a database you always need to use the address. It just happens to be that the database server is located behind the same IP address and thus localhost, which means the address 127.0.0.1, can be used.

1064324362[/snapback]

couldn't you also use your dns:3306, or maybe your subdomain.host:3306

 

 

$db = mysql_connect("Xisto.com:3306", "user", "pass");

I have an account @ cogia.net and it hosts mysql, but it's strange because it limits the free accounts to one database, so I haven't actually tried it with Xisto. Someone give it a go and tell me how it goes.

 

 

BTW here's what I use for cogia.net and it works fine.

$conn = mysql_connect("cogia.net:3306", "mydbname", "pass");

Cogia uses the db name as your user and database.

[yordan 10]

it limits the free accounts to one database

loot at your cpanel at Xisto, you will see your limits.I am currently using 7 databases, and I am allowed up to 99.
Of course, my free account will probably not have anouth megs for 99 databases, however you clearly can have several databases, as long as you don't exhaust the free space you are allowed.
Regards
yordan

[minnieadkins 0]

loot at your cpanel at Xisto, you will see your limits.

I am currently using 7 databases, and I am allowed up to 99.

Of course, my free account will probably not have anouth megs for 99 databases, however you clearly can have several databases, as long as you don't exhaust the free space you are allowed.

Regards

yordan

1064324502[/snapback]

Sorry, I must've written my message the wrong way. I don't have an Xisto account. I find it hard to juggle college, work, and just got married. (not to mention dial-up internet) I have to admit if I had broadband then it would be easier to remain an active member. Cogia.net however provides free php/mysql support with ad banners. I admit Xisto is a much better source, and I would engage in it if it weren't for my ability to remain absent from the net for weeks at a time.

 

I was referring to cogia.net when i said

 

it limits the free accounts to one database

The point of this tho was just stating that if you have mysql and php on the same server. You would use the same ip, but a different port, correct? MySql usually is on port 3306 if I'm not mistaken. I'm kinda new to this whole thing, but that's just my 2 cents.