Server question

[Guest Ed]

Are there seperate servers for the mysql databases or do they reside on the same servers as user's content?

 

Thanks,

Ed

ReadingEd.com

[KevinW]

they reside on your site, your server! With TCH and cPanel, you have the ability to backup your MmySQL dsatabase and assign user access to it as well.

-kw

[borfast]

I think the MySQL server is running on the same machine as the user's files.

 

To access the server in a script, I have to set the database server to localhost, so it means the server is running on the same machine.

 

But you should wait for an admin to confirm that.

[Lianna]

Yep, local as in "on your machine".

 

Lianna

[KevinW]

The term 'localhost' is actually a special keyword used in Unix/Linux environment to represent the web server that you are running on, and simply avoids having to hard code in your actual host name or IP address.

 

Example: here is a statement in MySQL/PHP:

mysql_connect(localhost,$username,$password);

 

This line tells PHP to connect to the MySQL database server at 'localhost' (localhost means the server that the site is running one. Unless you web host tells you otherwise you should use localhost) using the username stored in $username and the passoword in $password.

 

HTH!

-kw