Page 504 - Computer_Science_F5
P. 504
MySQL for e-commerce and online
business operations. The financial sector, Activity 8.22:
including banks and fintech startups, uses Installing MySQL using local
MySQL for transaction data and analytics. environments
Telecommunications companies and ISPs Materials Used: Chapter Eight: Databases and Database Management Systems
FOR ONLINE READING ONLY
use MySQL for managing subscriber
data, service provisioning, and billing Computer with Windows operating
systems, benefiting from its scalability system; Internet access; MySQL
Installer downloaded from https://
and reliability to deliver quality services. www.mysql.com
Community and ecosystem Aim:
MySQL has a vibrant community of To guide users through the installation
developers and users who contribute to of MySQL Community Server on a
its ongoing development and provide local Windows environment, enabling
support through forums, blogs, and them to set up and configure MySQL
database
and
management
for
third-party tools. This community- development purposes.
driven approach has resulted in a rich
ecosystem of tools, documentation, and Instructions:
resources that help users manage and Step 1: Download MySQL Installer
optimise MySQL databases effectively. (a) Visit https://www.mysql.
MySQL installation when using local com and download MySQL
environments Community Server edition.
(b) Run the installer and choose
As earlier indicated MySQL is a popular “Developer Default” setup.
open-source Relational Database
Management System (RDBMS) that Step 2: Select Products to Install
allows you to efficiently store and Choose “MySQL Server” and select
manage large amounts of structured data the latest version for installation.
and it is widely used by developers, data
analysts, and system administrators for Step 3: Configuration
various purposes, including building (a) Configure installation type as
web applications, managing content, “Server only” and choose port
number (default is 3306).
and performing data analysis. Using it (b) Set a strong root password for
with local environments requires the
installation which can be on different MySQL server access.
operating systems though here and in this Step 4: Installation
subject we focus on Windows as indicated (a) Execute the installation process
below in Activity 8.6. after configuring details.
495
Student’s Book Form Five
Computer Science Form 5.indd 495 23/07/2024 12:35
