Setting Up MySQL

[Krissy]

I'm a TOTAL newbie, so bear with me.

I set up a forum. It all went fine, EXCEPT I want it to be on one of my add-on domains only. I don't want ANY connection that can be traced or connected to my main domain.

When I created the database, it seemed to require my main domain user name and I can't figure out how to make it so that the forum is only on the add-on domain.

Thanks!

[felgall]

All databases sit in a central depository that is not directly associated with any account. The account identifier on the front of the database name identifies the account it belongs to. That database can then be used with any/all domains within that account. There is no connection between the domains you create in an account apart from the hidden ones that are there for your use only - unless you deliberately make the connection visible yourself.

If you uploaded the script for the forum to the folder associated with an add-on domain then that is where it will be accessible from.

[Krissy]

I REALLY appreciate your reply, but I still don't understand completely. When I set up an SQL Database, it always uses my main domain when it names the user and the database. How can I do all this setting up in my add-on domain?

I downloaded the forum from Simple Machines. I FTPed it to my add-on domain folder under Public_HTML. So right now it's in:

/public_html/addondomain/forum

When I install it, it will install into that folder, but like I said, the database and everything still requires the main domain as part of the path and naming.

I'm trying to do all this without the main domain name being public.

Thanks again!

[felgall]

You use your account name to access the database. Your account name is the same for both the main domain and any add-on domains in the same account.

For example I have an account with the account name felgallc. I have two domains using different databases - felgall.com (my main domain) uses a database called felgallc_felgall and amra.asn.au (an addon domain) uses a database called felgallc_amra

No one using either site has any way to tell what database is being used by what domain or what account the domain or database is in as none of that information is available to anyone who is visiting your site. You could even have all your domains use the same database if you want as long as there are no table name conflicts.

[Krissy]

OK. Thanks SO much. I'll give it another try. :)

[temhawk]

Hey, I have a question.

I'm setting up a phpBB3 forum on my site, but the installation process requires me to know some information about the database.

Where can I get this info?

PS: I have to know the following...

The Database Type - the database you will be using.
The Database server hostname or DSN - the address of the database server.
The Database server port - the port of the database server (most of the time this is not needed).
The Database name - the name of the database on the server.
The Database username and Database password - the login data to access the database.Thx in advance!