Skip to main content

Experiment 01

Aim​

To install MySQL Database Management System and understand its basic components

Requirements​

  • Hardware: Personal Computer/Laptop with at least 4GB RAM
  • Software: Windows 10/11, Linux, or macOS
  • Network: Internet connection for downloading MySQL installer
  • Disk Space: Minimum 2GB free space for installation

Procedure​

Step 1: Download MySQL

  • Visit the official MySQL website
  • Download MySQL Community Server (latest stable version)
  • Choose the appropriate installer for your operating system

Step 2: Run the Installer

  • Execute the downloaded MySQL installer
  • Choose installation type:
    • Developer Default: Includes MySQL Server, Workbench, and development tools
    • Server Only: Only MySQL Server
    • Custom: Select specific components

Step 3: Configuration

  • Server Configuration Type: Choose "Development Computer" for learning purposes
  • Port Number: Default port 3306 (change if needed)
  • Authentication Method: Use Strong Password Encryption
  • Root Password: Set a strong password for the root user

Step 4: Complete Installation

  • Apply configuration settings
  • Start MySQL Server as a Windows Service(recommended)
  • Complete the installation process

Step 5: Verify Installation

  • Open MySQL Command Line Client
  • Login with root credentials
  • Execute basic commands to verify functionality

Commands​

-- Check MySQL version
SELECT VERSION();

-- Show current date and time
SELECT NOW();

-- Display available databases
SHOW DATABASES;

-- Create a test database
CREATE DATABASE test_db;

-- Use the test database
USE test_db;

-- Create a simple table
CREATE TABLE test_table (
    id INT PRIMARY KEY,
    name VARCHAR(50)
);

-- Insert sample data
INSERT INTO test_table VALUES (1, 'Test Record');

-- Query the data
SELECT * FROM test_table;

-- Drop the test table and database
DROP TABLE test_table;
DROP DATABASE test_db;
Images

To be uploaded later...

Common Installation Issues and Solutions​

  • Port 3306 already in use: Change port number or stop conflicting services
  • Service won't start: Check Windows Services and restart MySQL service
  • Login denied: Verify username/password and authentication method
  • Connection refused: Ensure MySQL service is running

Conclusion​

Successfully installed MySQL Database Management System and verified its basic components and functionality.