Visit Jeremy's Blog.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 08-03-2003, 01:47 PM   #1
Registered: Jun 2002
Location: Wales, UK
Distribution: Gentoo 2005.1
Posts: 213

Rep: Reputation: 30
Question How to create a SQL Database in Linux?

How do you create a SQL database in Red Hat Linux 9 and host it on my site so that I can use PHP to retrive data from it?

P.S Site Aint Finished.
Old 08-03-2003, 01:49 PM   #2
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984
you install an SQL server like mysql or postgresql. Start it. Learn to use SQL....
Old 08-03-2003, 11:50 PM   #3
Registered: Jun 2003
Location: Toronto, Ontario, Canada
Posts: 288

Rep: Reputation: 30
That's right, get mysql/postgresql. Install it. Learn how to handle databases with PHP and some basic SQL. Now you are set.
Old 08-15-2003, 09:10 AM   #4
Registered: Jul 2003
Location: Louisville aka Derby City
Distribution: WinXP SP2 and SP3, W2K Server, Ubuntu
Posts: 313

Rep: Reputation: 30
To help you choose, I might suggest MySQL is more lightweight and somewhat easier to user because it cannot do as much as postgres. In its simplicity, you give up power, but the learning curve is less steep. Personally, I use postgres at home and DBA postgres at work (7.3.2). Its not bad after about 2-3 days of reading and you can make it easier by using tools like PGAdmin and others.
Old 08-16-2003, 03:31 AM   #5
LQ Guru
Registered: Apr 2002
Location: Atlanta
Distribution: Gentoo
Posts: 1,280

Rep: Reputation: 47
if you go with MySQL (that's what i use...and most books i see relate PHP to MySQL) make sure you configure php for mysql stuff. I think redhat does that automatically, or u can download an rpm what has it. if you want an easy way to manage databases, have perl installed with perl-DBI and download webmin from


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Restoring *.sql database from Linux Fedora's shell marciano Linux - Newbie 1 10-19-2005 06:05 PM
TOMCAT and MS SQL database shane200_ Programming 0 05-31-2005 10:52 AM
Is there a database manager for linux that is compatable with M$ Access and SQL? enigma Z Linux - Software 2 08-27-2004 08:50 PM
database needed not sql herc222 Linux - Software 3 03-08-2004 07:34 AM
SQL Database Administration GabeF Linux - Software 2 11-17-2002 07:28 PM > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 09:36 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration