Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / How do i create my own SQL database?

Author
Message
Fatal Berserker
14
Years of Service
User Offline
Joined: 2nd Jul 2010
Location:
Posted: 5th May 2011 21:52
Link
I really need to create my own SQL database, and i have no idea.
I have loads of applications that 'claim' to have the ability to create databases, but in reality they all claim they want login information to a database which doesnt exist.
Ive used SQL databases before but i have never actually made my own before. And i cant seem to get past these connection screens.

Can anyone help me please?

Back to top
Profile PM
bitJericho
22
Years of Service
User Offline
Joined: 9th Oct 2002
Location: United States
Posted: 5th May 2011 22:17
Link
are you talking about for a desktop environment? For your webhost? What?

[center]Jerico for President. Obese for VP
My dear tomato \ Please let me classify you \ A fregetable.
Back to top
Profile PM Email Website
Fatal Berserker
14
Years of Service
User Offline
Joined: 2nd Jul 2010
Location:
Posted: 5th May 2011 22:52
Link
desktop

Back to top
Profile PM
bitJericho
22
Years of Service
User Offline
Joined: 9th Oct 2002
Location: United States
Posted: 6th May 2011 00:11
Link
Something like wamp server should take care of what you need:

http://www.wampserver.com/en/

The database software is already configured and can be activated easily. Also, it includes phpmyadmin if I recall.

Alternatively, you can install a virtual machine to run on your desktop, and run it with something like virtualmin gpl which will give you a much more powerful setup.

I use this configuration for developing and for storing code.

[center]Jerico for President. Obese for VP
My dear tomato \ Please let me classify you \ A fregetable.
Back to top
Profile PM Email Website
Diggsey
19
Years of Service
User Offline
Joined: 24th Apr 2006
Location: On this web page.
Posted: 6th May 2011 00:12
Link
For a local database, I suggest SQLite. A database is not just a file, there are different parts:

- The SQL server
This is a program which actually runs the queries. It controls how the data is accessed. It is often on a remote server.

- The SQL client
This is the program which is using the database. It can't actually do anything on its own, it needs to have a connection to the SQL server.

SQLite is one of the few database engines that let you combine these two parts into one program.

[b]
Back to top
Profile PM Email Website
Oneka
21
Years of Service
User Offline
Joined: 24th Apr 2004
Location: Hampton,VA
Posted: 6th May 2011 03:23
Link
postgreSQL is what I currently use


Making dreams possible, one line at a time...
Back to top
Profile PM Email Website
That Guy John
15
Years of Service
User Offline
Joined: 30th Apr 2010
Location: United States
Posted: 10th May 2011 09:02
Link
I recomend WampServer and PHPmyadmin..

Video on downloading and installing WampServer:



Quick Video on creating a database using PHPmyadmin:



And Here Is A Penguin:
FPSC OneSource [DeskTop App] - Bringing everything together into one.
Back to top
Profile PM
Phaelax
DBPro Master
22
Years of Service
User Offline
Joined: 16th Apr 2003
Location: Metropia
Posted: 10th May 2011 09:08
Link
Xampp

Back to top
Profile PM Email Website
Fatal Berserker
14
Years of Service
User Offline
Joined: 2nd Jul 2010
Location:
Posted: 10th May 2011 18:48
Link
thanks for the help

Back to top
Profile PM
Back to top

Login to post a reply

Server time is: 2025-05-21 15:47:34
Your offset time is: 2025-05-21 15:47:34