MySQL And LAMP SoftwareMySQL And LAMP Software

MySQL is the world's most widely used database management system. You don't have to be a seasoned programmer to use MySQL on its own or as part of dynamic web sites for a very wide variety of database applications. This article introduces MySQL and the other LAMP components. First we will briefly present the history of MySQL.

SQL stands for Structured Query Language. This language dates back to 1970 in a paper written by Dr. E. F. Codd, researcher at IBM. This ground-breaking paper described the theoretical foundations of relational databases, databases that are based on tables. Oracle Corporation beat IBM to the punch by bringing the first such database management system to market in 1979. MySQL was released for Windows computers almost twenty years later. Over the years MySQL has evolved to become a major player in the very competitive SQL market for database management systems of all sizes.

MySQL belongs to the LAMP suite of free software known as open-source. The L refers to Linux, which is a Unix-based operating system that competes head to head with Microsoft Windows. If you want to run LAMP on Windows computers you must do two separate downloads, one for Linux and another such as downloading Easy PHP to obtain the remaining LAMP components. You may execute these three components on almost any Windows computer, even one that seemed way over the hill. Testing your web programs requires a browser such as Firefox or Internet Explorer but does not require a live Internet connection.

The A in LAMP stands for Apache which is the most widely used web server in the world. You can run Apache with MySQL and PHP, and test your programs in a live environment on a single computer.

PHP is a server-based program, it runs under Apache. The good news is that you only require a single computer to run PHP and develop and test your website. Of course for other people to access your website you will need to host the site on the Web. This means naming your site and dealing with a web-hosting company. You must shell out for your site name and usually for a company to host your domain. The web hosting company may charge extra for Linux and MySQL services and support. Many webmasters claim that Linux offers a more professional environment than does Windows. Others prefer the more familiar Microsoft Windows. It will be your choice.

by Levi Reiss
References and Bibliography
evi Reiss has authored or co-authored ten books on computers and the Internet. He loves the occasional glass of wine as exemplified by his wine websites including He teaches Linux and Windows operating systems plus other computer courses at an Ontario French-language community college. Visit his new website which teaches you how to download and run Damn Small Linux on Windows computers, even if they are "obsolete."
Rated:NR/0 Votes
Add To My Article Reading List
Add To My Article Reading List
Print Article
More Article By Levi Reiss
More Article by Levi Reiss
More Articles From MySQL
More Articles From MySQL
Related Articles and Readings
Database And Document Management Systems By: Eric Morris
Different business organizations use different types of software to manage their documents. This software performs the function of creating, full text indexing, controlling the different versions of documents, retrieval, and so on.The vital component of any document management software system is the inherent database management technology that classifies and tracks ...
Microsoft CRM Integration with Microsoft Retail Management System RMS Overview By: Andrew Karasev
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading software applications, such as QuickSell which is now Microsoft RMS. So, RMS design fundamentals were minted a long time before Microsoft CRM. But, still ...
Automated Link Management By: Michael Lawrence
Link popularity is an important part of any search engine optimization or traffic building campaign. Having relevant backlinks to your website from other authority websites in your chosen keyword space is essential to achieve good rankings with the search engines. In many cases you will find that webmaster's require a ...
Good Web Design What Is It By: Ryan Fyfe
There is unlimited possibilities when it comes to designing a website. Flash, Database, content management, Client Login, etc,etc. A question to ask yourself when deciding how to do your website is:How can I most effectively present my information to my visitorsOf course there are several things to consider like budget ...
How Database Approach Differs from Traditional File System Concepts By: Balajee Bashyaam
A database is a collection of interrelated data's stored in a database server; these data's will be stored in the form of tables. The primary aim of database is to provide a way to store and retrieve database information in fast and efficient manner.There are number of characteristics that differs ...
The information provided in this article and/or the comments is the sole responsibility of their respective authors and does not necessarily reflect the opinion of  does not endorse any article and/or comments published by our web users unless otherwise noted. 

Member Panel

login to submit articles and more


  • » Active Categories: 419
  • » Active Articles:252603
  • » Active Authors:31917
  • » Active Members: 38237
  • » Statistics Updated:
    - Tue Sep 1st, 2020 09:28AM EST