romeo123
Apr 20 2008, 12:46 AM
| | How do you access databases?Even though i don't have a hosting account yet i want to think ahead. Please help
thx,
romeo123 |
Reply
docduke
Apr 20 2008, 04:11 AM
It depends on what you want to do with them. Many people use server software packages such as MediaWiki (to make a clone of WikiPedia), or phpBB for bulletin boards. In each case, these programs use databases to store and retrieve the contents of their web pages. As a result, they take care of using the database themselves. Usually, to set up such a program, you first need to create a database account on the server, then tell the MediaWiki or phpBB software what the userid and password are for that account. Many "free" or low-cost hosting services limit users to very few database accounts. AstaHost does not.  That is one of the reasons I am here. If you really want to use one of these databases "barefoot," you need to study SQL. I really do not recommend that, as you will see here and here. If you are determined, have at it!  Otherwise, find an application that is already built, and close to what you want. In Windows, look at Ms Access, Writer's Project Organizer or Album Shaper. In Linux, look at Beagle or GnuCash, which you may find more of a challenge to install. On most modern operating systems, the "database engine" understands SQL commands, but the typical user finds an application that generates the SQL commands for him.
Reply
yordan
Apr 22 2008, 03:51 PM
More precisely, when you are hosted at astahost (like on most of modern host offering cpanel), once you clicked in "create a database" you are asked a lot of questions about the database name and the user name, and then you are provided with the connection strings for connecting to your database. The informations are like these, they explain how to connect depending if you connect from a perl program, or from php, or from JDBC : Connection Strings Perl $dbh = DBI->connect("DBI:mysql:myname_mydatabase:localhost","myname_mydatabase","<PASSWORD HERE>"); PHP $dbh=mysql_connect ("localhost", "myname_mydatabase", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("myname_mydatabase"); JDBC (may not be available) <%@ page import="java.sql.*" %> Connection connection = null; Class.forName("org.gjt.mm.mysql.Driver").newInstance(); connection = DriverManager.getConnection( "jdbc:mysql://localhost/myname_mydatabase?user=myname_mydatabase&password=<PASSWORD HERE>"); Of course, here at astahost, you will probably use pre-installed script. For instance the php installation and configuration scirpt will ask your for the database server (you enter "localhost"), the database name (the database name you just entered when creating the database) and the database administrator name. Hope this helped. Yordan
Reply
Similar Topics
Keywords : databases- Free Graphical Tools For Databases
- (7)
- Need Advice On Creating Online Music Database
- ps - dont know anything about databases! (6)
I need to create a database of around 1000 music albums that I can put on my site, with the ability
to search the database according to several different criteria. Being a complete and total NOOB to
the world of databases, can anyone point me in the direction of some software that will let me
create a good-looking and functional database, but that isn't too complicated for me to
use?! Sounds like a tall order I know, be grateful if anyone can help though. Thanks!
Topic edited to reflect content better. ...
All About Databases
- Info, for you! (3)
QUOTE Hi, I noticed there were a lot of questions in all of the database topics, so i went
around the internet using different sources, and have some information that will answer your
questions and help you understand databases. I hope this helps, and if you have any other questions
which arent answered below, please send a message asking. Thankyou. In computing, a database can be
defined as a structured collection of records or data that is stored in a computer so that a program
can consult it to answer queries. The records retrieved in answer to queries become i...
Examining Databases At A Whole Glance
- SQL-92 specification (7)
Most of us using databases or doing data minings are not aware of SQL-92 specification seemingly
these days. SQL-92 specifiaction is the SQL database query language standard. Oracle,mysql
postgresql,mssql and DB2 - most widely recognized SQL database programs - are all closely related to
SQL-92 specification for the use of query nevertheless how they implemented SQL-92 specification
features inside in the program. Implementation of SQL-92 specification features are applied in the
order of Oracle, postgresql and mysql. These databases might have specific database query...
How Do You Make Large Databases?
- (14)
In a game I'm working on, I would like to have a database of actors/actresses. I'm not sure
exactly how to do this. I'm pretty sure with the hosting here, I can only have 99 databases.
I'm a little lost as to how to make it. Can all the actors/actresses be put on one database
with the specific things I want to include (i.e. how well the do in each genre)? I'm new to
Mysql and just need some help as to where to start....
Ms Databases
- (6)
Hello, I can make my own MS Access database, but can anyone tell me how to make a password gate
that checks the user info with the database? Olie122333 /biggrin.gif"
style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />...
Can You Make Your Own MySQL Databases?
- Im an idoit (7)
Can you make your own MySQL database or do they have to be bought or found from a free site i really
need help on this guys please reply or send me a PM when you have the time because i need so much
help with this atm /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif"
/> thankyou very much regards Morex Gaming owner Jarvis...
What Is A Database How Do I Use One?
- : Information about Databases and how to get use them efficiently (7)
Hello All Let's start off by talking about what a database is and how it would be efficient
in using it. It wasn't until about a year and half ago now that I was first introduced to this
new age of Database. I discovered a lot of neat things and even learned about databases the very
long way. A database is exactly how it sounds its data that has a base. The base being the place
where you store all your data. If you have ever been to a library perhaps you have used the Index to
search for an author, this is a database of authors. Ever seen a rolodex on someo...
Copy Databases In phpMyAdmin
- (3)
i have just got hosting here on astahost and i have to copy my databases from my old server... is
there an easy way of doing this? in phpmyadmin? thanx in advance you know lol /wink.gif"
style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> ...
The Best Database
- databases (41)
te best database for my is sql server yukon for you?...
How To Setup SMF Databases?
- (4)
does anyone know how to set up a database for a SMF forum....
Updating A Database's Tables
- (10)
Is there an "easy" way to update a database's tables? Like for instance, I have my own
custom-coded member login system. Whenever I add a new feature that needs a database, I manually
have to download, update and upload the database. Is there an easy way I can do this?
THANKS!!! F...
Combining Databases
- Please help before I mess up! (4)
I am intergrading this Private Messaging system into my website so that my members can login and
access their PMs through the seprate PM software without loging in twice and registering twice since
if I left it as is, that is what they would have to do... All I really need is 1 single table to be
combined without damaging my few member's accounts (they are all friends, but I don't want
to tell them that I was playing with the database and lost your account information...
/rolleyes.gif' border='0' style='vertical-align:middle' alt='rolleyes.gif' /> ) Since I d...
Unexpected Database Crashes
- sometimes my astahost databases are down (0)
Sometimes some of my astahost databases are down. After a couple of hours or a couple of day they
are up again. Sometimes all of them are down at the same time, sometimes some of them are up and the
other ones are down. The symptom is that when I connect to the forum I have an error message, saying
"Parse error: parse error, unexpected '\"', expecting ',' or ';' in
/home/../../.../../index.php on line 25" It's not an error in my phpbb because it used to work
correctly. So, what happends ? I suppose that the databases crash if the astahost...
Hosting A Server On Database
- I'm a total noob at databases (6)
Well this might be in the wrong place or I might have no clue what im talking about but I heard
something. Is it possible to host like a .exe server such as a macromedia multiuser server on a
database such as MySQL or any other databases? I have a friend that said he did it but I think he is
lying. Thanks in advance!...
Creating Databases
- from programs (4)
I jsut went throught PC magazine today and i found out that you can actually create a database using
Microsoft Access and Excel. And computers and servers online can actually use these databases and
conduct queries with them. I've always though of databases as MYSQL, Microsoft SQL server and so
on. So it is possible to store data to a Microsoft Access database and manipulate it online?...
Migrating Databases
- Migrating from MSSQL Server to MySQL (2)
How to migrate my database from SQL Server to MySQL?...
Remote Databases
- How to allow remote connections? (4)
I am currently in a big-problem. I am trying to use a MySQL database on another host, and I am
hosting my forums, on another host, and I am trying to install the forums but the error that comes,
says that the remote connection canot be allowed. Can anyone help me on how to resolve this issue
and proceed further, or should I just wait for astahost.com to get an account? All suggestions
welcome! /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /> ...
Free Databases
- mysql,postgresql,SAPDB,sybase,DB2 (14)
this website offers Database hosting for free. Jus signup and u get u r own database .. it supports
mysql, postgresql, sapdb, sybase, db2 CODE http://freesql.org from the webpage QUOTE
This service is, and will remain, totally free. I have receive hundreds of Thank you emails from
all over the world telling me that having this service available has allowed them to practice and
learn without the burden of having to run their own server. ...
Looking for databases
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for databases
|
advertisement
|
|
