SQL Environment
Moderator: Edi
-
brothersinarm
- Padawan Learner
- Posts: 344
- Joined: 2002-12-17 08:51pm
- Location: I'm Lost!!!
- Contact:
SQL Environment
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.
Everyone knows the formation by which you achieved victory, yet no one knows the formations by which you were able to create victory
- Sun Tzu
- Sun Tzu
-
brothersinarm
- Padawan Learner
- Posts: 344
- Joined: 2002-12-17 08:51pm
- Location: I'm Lost!!!
- Contact:
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)
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)
Everyone knows the formation by which you achieved victory, yet no one knows the formations by which you were able to create victory
- Sun Tzu
- Sun Tzu
-
Faram
- Bastard Operator from Hell
- Posts: 5271
- Joined: 2002-07-04 07:39am
- Location: Fighting Polarbears
Have limited expiriense with SQL servers so this info might be incorrect.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)
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.
[img=right]http://hem.bredband.net/b217293/warsaban.gif[/img]
"Either God wants to abolish evil, and cannot; or he can, but does not want to. ... If he wants to, but cannot, he is impotent. If he can, but does not want to, he is wicked. ... If, as they say, God can abolish evil, and God really wants to do it, why is there evil in the world?" -Epicurus
Fear is the mother of all gods.
Nature does all things spontaneously, by herself, without the meddling of the gods. -Lucretius
"Either God wants to abolish evil, and cannot; or he can, but does not want to. ... If he wants to, but cannot, he is impotent. If he can, but does not want to, he is wicked. ... If, as they say, God can abolish evil, and God really wants to do it, why is there evil in the world?" -Epicurus
Fear is the mother of all gods.
Nature does all things spontaneously, by herself, without the meddling of the gods. -Lucretius
-
Darth Wong
- Sith Lord
- Posts: 70028
- Joined: 2002-07-03 12:25am
- Location: Toronto, Canada
- Contact:
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.
You'll need to have some database server software running on the local machine, such as MySQL or Microsoft SQL Server.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 need to log into the database server and create a database before you can set up your software.[/quote]SQL Database Name
These will be set up in your database software config.SQL Username
SQL Password
Tables are what actually stores the data. There can be many tables inside a single database.SQL Table Prefix(You can leave this blank)
"you guys are fascinated with the use of those "rules of logic" to the extent that you don't really want to discussus anything."- GC
"I do not believe Russian Roulette is a stupid act" - Embracer of Darkness
"Viagra commercials appear to save lives" - tharkûn on US health care.
http://www.stardestroyer.net/Mike/RantMode/Blurbs.html
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.
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.
BoTM, MM, HAB, JL
