Portal Home > Knowledgebase > Articles Database > Mysql


Mysql




Posted by aakburns, 09-11-2005, 10:02 PM
Hi, I'm learning all i can right now. Can someone briefly tell me exactly what Mysql is and what it does? Thanks for any help -Arik

Posted by andren, 09-12-2005, 12:06 AM
It's a database. It stores the data you (or an application) hands it. All data is stored in tables, but you can ask it to check all tables. Databses that store only tables are called relational databases. SQL (Structured Query Language) is a language that was developed to talk to applications that store tables. Therefore MySQL. Of couse you can also ask it to hand data back to you - and that 's where its really useful, because it is very fast at finding things you told it to remember.

Posted by aakburns, 09-12-2005, 12:39 AM
So would a forum use mysql? As a way to find posts from different users and things along those lines?

Posted by omaha.stylee, 09-12-2005, 02:37 AM
that would be correct. a forum uses a database hosted on the mysql server.

Posted by mripguru, 09-12-2005, 10:44 AM
www.mysql.com

Posted by ByteMaster, 09-12-2005, 02:12 PM
Think of a database like this. As an example, your address book. That is a database. Each name in it with all of the info associated with the name, is a RECORD. Each name, address, phone and so on are FIELDS and are part of each RECORD. All fo these comprise a DATABASE. You could think of a book of recipes as a database as well. You get the idea. MySQL is a brand of database. Microsoft Access, Microsoft SQL Server, Postgre, Oracle, and more, are other 'brands'. MySQL is the most common database used in UNIX based web hosting, mostly because it is free and has an enormous user and development following. It is very stable and user feindly. Especially if the host you choose has a GUI front end to it such as phpMyAdmin.

Posted by aakburns, 09-12-2005, 11:37 PM
Hmm, so if i have mysql enabled on my hosting server, that will allow for anyone to run something such as a php forum that runs using mysql? This thread has really help'd me to understand this. Thanks everyone -Arik

Posted by andren, 09-12-2005, 11:53 PM
Not the visitors, only actual users on the server can run a forum. Visitors can read and post if give them permission to do so.

Posted by Cool Surfer, 09-14-2005, 10:55 AM
your members or visitors on ur forum cant actually see the sql of ur forum. It runs in the background. U can say that the forum is a graphical interface of the sql it uses. Never give anyone ur sql name n password. Its risky. U can install IIS server with php n mysql and learn a lot more about these simple yet very important questions. also check out this site



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
Hostdime or Crocweb? (Views: 623)