Welcome to Database Laboratory
Welcome to Database Laboratory
.Net Framework version 4.6 or later
vc++ redistributable
MYSQL Community Server
Part 1: MySQL
Step 1: Download MySQL
Go to the MySQL website.
Download the MySQL Installer for Windows.
Step 2: Install MySQL
Run the downloaded installer.
Choose the setup type (Developer Default, Server only, etc.). For most cases, "Developer Default" is recommended.
Click Next and follow the on-screen instructions to proceed with the installation.
Step 3: Configure MySQL Server
Once the installation is complete, the MySQL Installer will prompt you to configure the MySQL Server.
Set up the server configuration type (Standalone MySQL Server, InnoDB Cluster, etc.). Choose "Standalone MySQL Server".
Configure the server (e.g., port number, default is 3306).
Set up the authentication method. You can choose to use the legacy authentication method or the recommended strong password encryption.
Create a root password and add any additional user accounts if necessary.
Apply the configuration and complete the setup.
Step 4: Verify MySQL Installation
Open the MySQL Command Line Client or MySQL Workbench.
Log in using the root user and password you created during the installation.
Run a simple SQL command to verify the installation:
SHOW DATABASES;
Part 2: MongoDB
Step 1: Download MongoDB
Go to the MongoDB website.
Select the appropriate version for Windows and download the installer.
Step 2: Install MongoDB
Run the downloaded installer.
Follow the installation wizard. Select the "Complete" setup type for a full installation.
During the installation, you can choose to install MongoDB as a service, which allows it to start automatically with the system.
Step 3: Configure MongoDB
By default, MongoDB stores its data in C:\Program Files\MongoDB\Server\<version>\data\db.
You can configure MongoDB by editing the mongod.cfg file, typically located at C:\Program Files\MongoDB\Server\<version>\bin\mongod.cfg.
Example configuration (mongod.cfg):
systemLog:
destination: file
path: C:\Program Files\MongoDB\Server\<version>\log\mongod.log
storage:
dbPath: C:\Program Files\MongoDB\Server\<version>\data\db
net:
bindIp: 127.0.0.1
port: 27017