MySQL INTRODUCTON

  So after learning HTML lets go into the working part
    lets first see what is MySQL and then go to php  

           MySQL is installed on every continent in the world (Yes, even Antarctica!) MySQL AB MySQL is a relational Database Management System (RDBMS). MySQL AB develops and markets a family of high performance, affordable database servers and tools. Contributing to building the mission-critical,high-volume systems and products worldwide is what makes MySQL the world’s most popular open source database, as well as its reliability, excellent performance and ease of use. MySQL is not only the world’s most popular open source database, it’s also the fastest growing database in the industry, with more than 11 million active installations and 50,000 downloads per day. The company was founded in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael "Monty" Widenius who have worked together since the 80's. MySQL AB(Swedish for “Inc.”) is the sole owner of the MySQL server source code, the MySQL trademark and the MySQL .com domain worldwide. MySQL has always been a strong supporter of the Open Source philosophy and the Open Source Community, and strives to work with partners that share the same values and mind-set. 

  
    •  The MySQL mission: To make superior database software available and affordable to all. 

 MySQL Products 
        MySQL provides database products to meet the needs of ISV/OEM, Enterprise, and Community Server users. MySQL database products are recognized for superior ease of use, performance, and reliability.

•  Enterprise Server 
   

           The most reliable, secure and up-to-date version of the world's most popular open source database for cost-effectively delivering E-commerce, Online Transaction Processing (OLTP), and multi-terabyte Data Warehousing applications. (Available only with the MySQL Enterprise subscription). 

•  Community Server

             The MySQL database server for open source developers and technology enthusiasts who want to get started with MySQL. Supported by the large MySQL open source community. Under the General Public License (GPL), benefits to the open source community include a commercial-grade framework that is free of charge. 

•  Embedded Database 

            The most popular choice for OEMs/ISVs who want to cost-effectively embed or bundle a reliable and high-performance relational database. 

•  Cluster 

           A fault tolerant database clustering architecture for deploying highly available mission-critical 

database applications. 

•  MaxDB 

          Formerly known as SAP DB, MaxDB is the result of a strategic alliance between MySQL and 

SAP to jointly develop and market an open source database for SAP/R3

MySQL Enterprise 

         A comprehensive set of enterprise-grade software, support and services directly from the developers of MySQL to ensure the highest levels of reliability, security and uptime. As a proactive service that helps you eliminate problems before they occur, it gives you everything you need in a single, unified offering to 

successfully develop and deploy business critical applications using MySQL. 

•  Enterprise Server 

         The most reliable, secure and up-to-date version of the world's most popular open source database for cost-effectively delivering E-commerce, Online Transaction Processing (OLTP), and multi-terabyte Data Warehousing applications. 

•  Network Monitoring and Advisory 

            Services to ensure the maximum quality, uptime, and performance of MySQL Enterprise systems. 

•  Production Support  


           Around-the-clock support for the MySQL Enterprise server, along with consulting services and self-help knowledge aids.



MySQL GUI Tools 


          A comprehensive set of open source visual database tools. These easy to use visual tools enable database developers and DBAs to be more productive.

•  MySQL Migration Toolkit 


         Using a wizard-driven interface, the MySQL Migration Toolkit implements a proven methodology and walks you through the necessary steps to successfully complete a database migration project.

•  MySQL Administrator 


          A powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating.

•  MySQL Query Browser 


        An extremely user-friendly visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server.


•  SQLyog Community
       SQLyog is a GUI tool for the RDBMS MySQL. It is developed by Webyog, Inc. based out of Bangalore, India and Santa Clara, California.


SQLyog is available in free as well as paid versions. The free version is known as Community Edition and is available as an open source project . Paid version are sold as Professional, Enterprise and Ultimate Editions .
       To download Community Edition click here

MySQL Drivers 

         Standards-based drivers (also known as Connectors) enable developers to build database applications in 

their language of choice. In addition, a native C library allows developers to embed MySQL directly into their ‘C’ applications. MySQL provides the following drivers: 

•  MySQL Connector/ODBC 

      Connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms. 

•  MySQL Connector/J 

          A native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database.

•  MySQL Connector/Net 

         An ADO.NET provider that allows access  from the .NET platform using the network protocol used by the MySQL database.

•  MySQL Connector/MXJ 

        An MBean that allows seamlessly embedding the MySQL database server within the J2EE environment. 

•  MySQL Connector/PHP (New to the MySQL family of Connectors) 

      

       For connecting to MYSQL from PHP on Windows (not necessary for Unix variants). 

To download Drivers click here