Introduction to MYSQ

Document Sample
Introduction to MYSQ Powered By Docstoc

                                  Introduction to MYSQL
1.1. DataBase
                 Database (database) is a collection of information stored in a computer in a systematic way
     so that it can be accessed using a computer program to obtain information from the database. The
     software used to manage and query a database call is called a database management system (DBMS
     database management system).
1.2. MySQL
                 MySQL is a DBMS multithreaded, multi-user who is popular with about 6 million
      installations worldwide. MySQL AB makes MySQL available as free software under the GNU
      PUBLIC LICENSE GEBERAL (GPL), and a commercial license for cases where users do not fit
      with the GPL. Not the same with projects like Apache, where the software was developed by the
      general community, and the copyright for the source code are owned by their respective authors,
      MySQL is owned and sponsored by a Swedish company MySQL AB, which holds the rights to
      almost ideal for all the source code .
                 MySQL is a Relational Database Management System (RDBMS) that is distributed for free
      under GPL. Where everyone is free to use MySQL, but should not be used as a derivative that is
      closed source or commercial. MySQL is actually a derivative of one of the main concepts in the
      database for a long time, the SQL (Structured Query Language). SQL is a database operation
      concept, teutama for election or selection and data entry, which allows the operation of the data is
      automatically done easily. Reliability of a database system (DBMS) can be determined from the
      optimization process the way it works in SQL commands created by the user or application
      programs. Some of the features of MySQL include:

    a. PORTABILITY, MySQL can run stable at a variety of operating systems like Windows, Linux,
       FreeBSD, Mac OS X Server, Solaris, Amiga, etc..

    b. OPEN SOURCE, MySQL is distributed as open source (free), under the GPL license so it can be
       used for free of charge.

    c. MULTIUSER, MySQL can be used by several users at the same time without experiencing any
       problems or conflicts are fatal.

1.3. Instalasi MYSQL-5.0.51b-win32.exe :
     1. Run the setup file mysql, the mysql-5.0.51b-win32.exe, the installation dialog will appear as

To display one at a time when running the setup file.

    2. Select the next button, and then the installation type dialog appears as follows:


The second appearance as a typical installation option, complete or custom fit the user.

    3. Select typical and next


When selecting the options will appear in the typical top, to the installation folder location info.

    4. Select the install button it starts the installation process.

Look after the installation process is complete.

    5. Click the finish button will display the following


Select or check the standard configuration for the standard configuration.

    6. Click next above it will display the following

Select or check the install as windows service to run mysql on windows.

    7. Click the button next column will appear the following dialog for password or not charging


Function of the column above is the option to use a password on mysql is already installed or not.

    8. Klik tombol execute untuk tahap akhir


End view of the configuration of mysql.

     9. Click finish
1.4. Menjalankan Client MySQL
     1. Start - all program - MySQL Server 5.0 – MySQL Command Line Client.


For the location of MySQL on the Start Menu program.

    2. Subsequently faced with the MySQL Command Line Client window. Enter password at depth
       appear as the following views:

At this stage of charging pasword, pasword filled when the stage filled password field configuration, but
if not to look at filling password above do not need the IDI and the further time by pressing the Enter key
on the keyboard.

    3. If successful login, the main page will appear MySQL prompt as shown below:


Above the main display MySQL Prompt to start the creation of a database.

1.5. Knowing the location of the Database Storage

By default MySQL has a sub directory named data to store all the database and tables are formed. The
composition of the resulting MySQL directory, if accessible to Windows Explorer will look like a normal
directory, in which there are several tables in a file as follows.

Shared By:
Description: Introduction to MYSQ