Page 1 of 1

SQL Environment

Posted: 2003-05-06 05:00pm
by brothersinarm
Could anyone answer some questions about SQL. Right now I'm trying to install a php board on my site, because the proboards was getting annoying, epecially the popups. Anyways I have no idea what SQL is or how to use it, and the board requires the use of SQL. If anyone can help I'd really appreciate it thanks.

Posted: 2003-05-06 05:02pm
by brothersinarm
PS. These are the fields which I have to fill in but I don't have a clue what they are.

This section requires you to enter your SQL information. If in doubt, please check with your webhost before asking for support. You may choose to enter an existing database name, if not - you must create a new database before continuing.

SQL Host
(localhost is usually sufficient)
SQL Database Name
SQL Username
SQL Password
SQL Table Prefix(You can leave this blank)

Posted: 2003-05-06 05:32pm
by Faram
brothersinarm wrote:PS. These are the fields which I have to fill in but I don't have a clue what they are.

This section requires you to enter your SQL information. If in doubt, please check with your webhost before asking for support. You may choose to enter an existing database name, if not - you must create a new database before continuing.

SQL Host
(localhost is usually sufficient)
SQL Database Name
SQL Username
SQL Password
SQL Table Prefix(You can leave this blank)
Have limited expiriense with SQL servers so this info might be incorrect.

Host=The Server where the SQL is installed
DB Name=Witch database do you vant to connect to?
DB Username=Usualy SA for MS SQL dunno about others
DB Password= Duh ;)
And no clue sorry.

Posted: 2003-05-06 05:44pm
by Darth Wong
SQL is Structured Query Language. It is a fairly standardized command-set for talking to database servers. It is a public standard and it is the reason why Microsoft has been unable to corrupt and "de-commoditize" the database market the way they've done for other markets.
brothersinarm wrote:PS. These are the fields which I have to fill in but I don't have a clue what they are.

This section requires you to enter your SQL information. If in doubt, please check with your webhost before asking for support. You may choose to enter an existing database name, if not - you must create a new database before continuing.

SQL Host
(localhost is usually sufficient)
You'll need to have some database server software running on the local machine, such as MySQL or Microsoft SQL Server.
SQL Database Name
You need to log into the database server and create a database before you can set up your software.[/quote]
SQL Username
SQL Password
These will be set up in your database software config.
SQL Table Prefix(You can leave this blank)
Tables are what actually stores the data. There can be many tables inside a single database.

Posted: 2003-05-06 07:15pm
by Exonerate
I'd recommend MySql. The host is usually localhost or 127.0.0.1, and if your host has a MySql database, they should provide you with the password and user account for it. If not, you'll have to ask them.

If you're going to do this on your own machine, you'd probably want to get it from http://www.mysql.com/. There should be a binary self-installing package for Win32, and an utility that will set it up for you automatically.

Posted: 2003-05-06 07:59pm
by Shadow
What is your host?