LLO 1.1: Install database software (MySQL database software)

DBMS Practical Journal

LLO 1.1: Install Database Software
Topic: Installation of MySQL Database Software

Objective:
To install MySQL database software on the computer system.

Software Required:

  • MySQL Community Server (latest stable version)

  • MySQL Workbench (optional but recommended for GUI)

Pre-requisites:

  • A computer with Windows/Linux/Mac operating system

  • Internet connection to download the installer files

  • Administrator rights on the system

Step-by-Step Procedure:

  1. Download MySQL Installer

    • Open your preferred web browser.

    • Go to the official MySQL website: https://dev.mysql.com/downloads/

    • Select MySQL Community Server.

    • Choose the installer suitable for your operating system (Windows/Linux/Mac).

    • Click on the download link and save the installer file.

  2. Run the Installer

    • Locate the downloaded installer file in your Downloads folder.

    • Double-click the installer to start the installation process.

  3. Installation Wizard

    • Follow the on-screen instructions of the installation wizard.

    • Choose the setup type (Typical, Custom, or Complete). For beginners, select Typical.

    • Proceed by clicking Next.

  4. Configuration

    • When prompted, configure the MySQL server settings.

    • Set the root password (remember this for future login).

    • Choose to allow MySQL to run as a Windows service (for Windows OS).

    • Complete the configuration and click Finish.

  5. Verify Installation

    • Open Command Prompt or Terminal.

    • Type mysql -u root -p and press Enter.

    • Enter the root password you set earlier.

    • If the MySQL shell opens, installation is successful.

  6. (Optional) Install MySQL Workbench

    • Download MySQL Workbench from the same MySQL download page.

    • Install it to have a graphical user interface for managing databases.

Result:
MySQL database server has been successfully installed and configured on the computer.

Precautions:

  • Keep the root password secure.

  • Ensure all downloads are from the official MySQL website.

  • Close all other applications during installation to avoid conflicts.

Conclusion:
By following the above steps, MySQL database software was installed on the system successfully. This will allow creating, managing, and querying databases as required in the DBMS course.


Popular posts from this blog