Basic Walkthrough MySQL Part-1

 

Basic Walkthrough MySQL Part-1

What is MySQL

MySQL Server is a relational database management system (RDBMS) developed by Sun Microsystems. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. MySQL server works in client-server architecture; hence it supports two types of components − (a) Workstation and (b) Server.

·        Workstation components are installed in every device/SQL Server operator’s machine. These are just interfaces to interact with Server components. Example: MySQL Workbench, phpMyAdmin etc.

·        Server components are installed in centralized server. These are services. The two most common and popular MySQL database engines are MyISAM and InnoDB. MyISAM is the default engine for MySQL for versions earlier than 5.5.5, and functions well in most scenarios.

Installing MySQL Community

            MySQL for Windows may be downloaded from MySQL.com.

A free "MySQL Community Server" edition is available in both 32-bit (x86) and 64-bit (x64) versions, depending upon whether your Windows server runs a 32 or 64-bit Windows operating system (the installer for either version is itself 32-bit).

Both a "web" installer and a "standalone" installer of the MySQL Community Server are available, for our current exercise we will use downloaded standalone installer.

 

 

1.      Click mysql-installer-community-5.6.42.0

 

2.      Click Install MySQL Products

 

 

4. Accept the license agreement and click Next.

 

 

5. Select Server only.

 

 

6. Check Requirements screen.

 

 

7. Ready to Install – shows MySQL Server 5.6.13.

 

 

8. Just normally displaying the installation progress.

 

 

9. Installation will progress.

 

 

10. Finally installation succeeds. Click Next. Server configuration wizard opens.

 

 

 

 

 

 

 

 

11. To install MySQL-Workbench CE insert CD containing mysql-workbench-community-6.0.9-win32.msi installer.

 

 

12. Double click the installer – it may ask for C++ Redistributable, will proceed after having C++ runtime installed, welcome screen is shown.

 

 

13. Confirms install directory and then you can choose complete of custom installation.

 

 

14. Ready to install screen, press Install button.

 

 

15. Installation progress is shown.

 

 

16. It completes really quick. You can leave checkbox checked to test run the Workbench.

 

 

17. As workbench loads you can click the database to explore. Skila_full is database name shown in lower left corner.

 

 

18. As you click the database it opens in design mode showing EER diagram.

 

 

19. Now you can close the workbench and start the command line client.

 

 

20. click MySQL 5.6 Command Line Client, it will ask for password.

 

 

21. You can check how many databases are installed by default using show databases command.

 

 

This concludes first chapter – installation or MySQL 5.6 CE.