CHAPTER – 15 RELATIONAL DATABASE
MANAGEMENT SYSYTEM
Installing MYSQL on Windows
Download MySQL Installer
If you want to install MySQL on the Windows environment, using
MySQL installer is the easiest way. MySQL installer provides you with
an easy-to-use wizard that helps you to install MySQL with the
following components:
1. MySQL Server
[Link] Available Connectors
[Link] Workbench with Sample Data Models
[Link] Notifier
[Link] for Excel and Microsoft Visual Studio
[Link] Sample Databases
[Link] Documentation
To download MySQL installer, go to the following link
[Link]
Installation Steps
To install MySQL using the MySQL installer, double-click on the MySQL
installer file and follow the steps below:
Installation Steps
Install MySQL Step 2 – Welcome Screen: A welcome screen provides
several options. Choose the first option: Install MySQL Products
Installation Steps
Step 3 – Download the latest MySQL products: MySQL installer checks and downloads the
latest MySQL products including MySQL server, MySQL Workbench, etc.
Installation Steps
Step 4: Click the Next button to continue
Installation Steps
Step 5 – Choosing a Setup Type: there are several setup types available.
Choose the Full option to install all MySQL products and features.
Installation Steps
Step 6 – Checking Requirements
Installation Steps
Step 7 – Installation Progress: MySQL Installer downloads all selected products. It will take
a while, depending on which products you selected and the speed of your internet
connection.
Installation Steps
Step 7 – Installation Progress: Complete Downloading. Click
the Next button to continue…
Installation Steps
Step 8 – Configuration Overview. Click the Next button to configure
MySQL Database Server
Installation Steps
Step 8.1 – MySQL Server Configuration: choose Config Type and MySQL
port (3006 by default) and click Next button to continue.
Installation Steps
Step 8.2 – MySQL Server Configuration: choose a password for the root account. Please
note the password download and keep it securely if you are installing MySQL database
server on a production server. If you want to add a more MySQL user, you can do it in this
step.
Installation Steps
Step 8.3 – MySQL Server Configuration: choose Windows service details including
Windows Service Name and account type, then click Next button to continue.
Installation Steps
Step 8.4 – MySQL Server Configuration – In Progress: MySQL Installer is configuring
MySQL database server. Wait until it is done and click the Next button to continue.
Installation Steps
Step 8.5 – MySQL Server Configuration – Done. Click the Next button to continue.
Installation Steps
Step 8.6 – Configuration Overview: MySQL Installer installs sample databases and sample
models.
Installation Steps
Step 9 – Installation Completes: the installation completes. Click the Finish button to close
the installation wizard and launch the MySQL Workbench.
Thank You