DBMS LAB
Assignment no. 1
Objective: Installing Oracle/MySQL
Description: MySQL is an open-source relational database management system
(RDBMS) that uses Structured Query Language (SQL) to store, organize, and retrieve data
efficiently. It stores data in tables (rows and columns) and allows relationships between
different tables, making it powerful for handling large amounts of structured data.
It’s known for being fast, secure, and easy to use, which is why it’s widely used in web
applications along with PHP, Java, and Python — for example, in the popular LAMP stack
(Linux, Apache, MySQL, PHP).
Hardware and Software requirements for MySQL:
💻 Hardware
Minimum 1 GHz processor (multi-core recommended)
At least 512 MB RAM (2 GB or more recommended)
Minimum 500 MB of free hard disk space (more if storing large data)
Standard VGA display (1024×768 resolution or higher)
🧠 Software Requirements
Operating System: Windows 10 or later, Linux (Ubuntu/CentOS), or macOS
MySQL Community Server (latest version)
MySQL Workbench (optional GUI tool for managing databases)
Web server/software (optional): Apache or Nginx (for web-based apps)
Programming language support (optional): PHP, Python, or Java
Visual C++ Redistributable (required for Windows installation)
Install MySQL for Windows Steps:
Steps to Install MySQL on Windows
1. Download MySQL Installer
o Go to the official MySQL website and click the download button
o
2. Go to the download sections
On the My SQL homepage, Click on the “No thanks, just start my download” link to
proceed MySQL downloading.
3. Run the Installer
After MySQL downloading [Link] file go to your downloads folder, find the
file, and double click to run the installer.
4. Choose setup type
The installer will instruct you to choose setup type For most users, the developer
default is suitable. Click Next to proceed
5. Check requirements
You might be prompted to install necessary MySQL software Typically, Visual code
installer can auto-resolve some issues, but not in this case.
6. MySQL Downloading
Now that you are in Downloads section, click Execute to start downloading the
components you selected. Wait a few minutes until all items show tick marks
indicating completion before moving forward.
7. MySQL Installations
Now that downloaded components will be installed, click Execute to start the
installation process. MySQL will be installed on your Windows system, then click
Next to proceed.
8. Navigate to View Configuration Pages.
Proceed to Product Configuration, Type, and Networking, Authentication Method.
Pages by clicking the Next button.
9. Create MySQL Accounts
Create a password for the MySQL root user. Ensure it's strong and memorable. Click
Next to proceed.
10. Connect to Server
Enter the root password. Click Check. If it says Connection Succeeds, you have
successfully connected to the server.
11. Complete Installations
Once the installation is complete, click Finish. Congratulations, MySQL is now
installed on your Windows system.
12. Verify Installations
To ensure successful installation of MySQL, open the MySQL command line client or
MySQL Workbench, both available in your start menu login using the root user
credentials you set during installation.
MySQL Workbench is ready to use.
MySQL is an open-source relational database management system that is based on
SQL queries. MySQL is used for data operations like querying, filtering, sorting,
grouping, modifying, and joining the tables present in the database.
MySQL installation on Windows post-installation steps.
Once MySQL is successfully installed, you can manage and interact with your databases in
several ways.
1. Create databases and tables.
You can now create a new database using the MySQL Workbench interface or via the
command line using SQL commands.
Example: create database, mydatabase;
2. Start using MySQL.
Start interacting with your databases using SQL queries or concepts. Connect MySQL
to other programming languages like Python, PHP, Java, and [Link] to build your
application's backend.