MYSQL INSTALLATION GUIDE

MySQL Installation Guide

This section guides the installation and setup of the MySQL database.
Install MySQL Server
On Windows:
1. Download MySQL Community Server from MySQL Official Website.
2. Run the installer and choose the Server Only option.
3. Configure the following settings:
  • Port: Default 3306.
  • Authentication: Use Legacy Password Encryption for compatibility.
4. Set the root password during installation.
On macOS:
1. Use Homebrew to install MySQL:
Copy code
brew install mysql
2. Start the MySQL service:
Copy code
brew services start mysql
3. Set the root password:
Copy code
mysql_secure_installation
On Linux (Ubuntu):
1. Update the system:
Copy code
sudo apt update
2. Install MySQL Server:
Copy code
sudo apt install mysql-server
3. Secure MySQL installation:
Copy code
sudo mysql_secure_installation
4. Start MySQL service:
Copy code
sudo systemctl start mysql