Modul1 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 follows: analysis: 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: analysis: The second appearance as a typical installation option, complete or custom fit the user. 3. Select typical and next analysis: 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. analysis: Look after the installation process is complete. 5. Click the finish button will display the following analysis: Select or check the standard configuration for the standard configuration. 6. Click next above it will display the following analysis: 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 analysis: 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 analysis: 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. analysis: 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: analysis: 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: analysis: 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.