MySql Database

1. Relational Database Management System (RDBMS): Manages data organized into tables with rows and columns, using SQL for querying and manipulation.
2. NoSQL: Databases diverging from the relational model, handling unstructured or semi-structured data, providing flexible schema designs.
3. Graph Database: A type of NoSQL database using graph structures (nodes, edges, properties) for data representation and querying complex relationships efficiently.

Installation Steps:

1. Download MySQL:

• Visit the official MySQL website: MySQL Downloads
• Under the MySQL Community (GPL) Downloads section, select the appropriate version for Windows.
• Choose the installer package according to your system architecture (32-bit or 64-bit).

2. Run the Installer:

• Once the installer is downloaded, double-click on the executable file to start the installation process.

3. Setup Wizard:

• The installation wizard will guide you through the installation process. Click “Next” to proceed.

4. Choose Setup Type:

• Select “Custom” setup type if you want to customize the installation options, otherwise, you can choose the “Developer Default” setup for a standard installation.
• Click “Next” to continue.

5. Select Products and Features:

• Here, you can select the MySQL products and features you want to install. By default, the MySQL Server and MySQL Workbench are selected.
• Click “Next” to proceed.

6. Installation:

• Choose the installation directory for MySQL. By default, it will be installed in the Program Files directory.
• Click “Next” to start the installation process.

7. Configure MySQL Server:

• During the installation, you will be prompted to configure MySQL Server. You can choose the server configuration type based on your requirements.
• Set a root password for MySQL. Make sure to remember this password as it will be required to access MySQL later.
• Click “Next” to continue.

8. Installation Complete:

• Once the installation is complete, you will see the “Completing the MySQL Server Setup Wizard” screen.
• Check the “Start MySQL Server at System Startup” option if you want MySQL Server to start automatically when Windows boots.
• Click “Finish” to exit the wizard.