Home » Technology » MySQL

MySQL

  • What is MySQL? MySQL Setup
  • Developed in 1994 and first released on May 23, 1995, MySQL is a multi-threaded, multi-user, fast and powerful database management system for more than 6 million systems.

 

  • It is available for free on platforms such as UNIX, OS / 2, and Windows, as well as paid commercial licenses. It performs better on Linux. Open source code MySQL is available as downloadable versions of binary code that can work on many platforms.

 

    mysql dolphin

  • MySQL developers have stated that they have maintained their own databases of about 100GB in MySQL, which consist of 10bin tables and 7 million records. Asp can be used with many web programming languages ​​such as php and is the most used database management system on web servers because it solves the problem of access rights in multiuser systems successfully. MySQL support for “transaction” with version 4.0, subquery support for version 4.1.

 

  • MySQL
  • MySQL supports the following database objects, some of which come with version 5.1:

 

  • Tables (Table)
  • Views (Display)
  • Procedures (Procedure)
  • Triggers
  • Cursors
  • Release Notes

 

 

 

  • 1994 MySQL development started.
  • May 23, 1995 The first release of MySQL is released.
  • In 2001 MySQL 3.23 was released.
  • 2004 MySQL 4.1 beta version, and the real version released in October 2004. (R-trees and B-trees, subqueries, prepared statements)
  • 2008: MySQL 5.1 release released. (Event scheduler, partitioning, plugin API, row-based replication, server log tables)
  • January 2008: Sun Microsystems buys MySQL for $ 1 billion.
  • April 2009: Oracle acquired Sun Microsystems. Oracle announced that it will continue to develop MySQL.

 

  • MySQL Installation, setup instructions
  • First, download the MySQL Installer package from the MySQL official site.
  • If you run the downloaded .msi extension file, click “Install MySQL Products” in the window that appears.
  • Accept the license terms and click the “Next” button.
  • Press the “Execute” button in the incoming window. If you are connected to the internete, the program will search for the latest package contents and update to the installation package. If you have just downloaded the MySQL Installer package, no updates will be made.

 

  • The next window will give you 5 different options for installation:
  • Developer Default: An option that installs all package content.
  • Server only: An option only installed by Server.
  • Client only: An option to install all package content except Server.
  • Full: A package of all package content.
  • Custom: An option that allows the user to select packages to install.

 

  • Here we select Developer Default and press the “Next” button. You can change the option to suit your needs.
  • The next window will check the programs that should be in your system depending on the type of installation selected. If it finds a deficiency, it downloads and installs it. When done, press “Next” button.
  • Start the installation by pressing the “Execute” button:
  • After all the setups have finished, press “Next” button.
  • After configuring the products displayed in the next window, press “Next” button.
  • After selecting “Developer Machine“, press “Next” button.

 

  • Select the “Enable TCP / IP Networking” and “Create Windows Service” options in the incoming window. In the “Port Number” section enter a port number (3306) and a service name in the “Windows Service Name” section. After making the password entries, check the options and press “Next” button.
  • Finally, finish the installation by saying “Finish“.
  • MySQL was installed successfully and will start automatically.
MySQL
Author: wik Date: 11:16 pm
Technology

Wik's Random Content