Step-by-Step guide to installing MySQL Server

Step-by-Step guide to installing MySQL Server  

Step 1: Download MySQL Installer 

  1. Open your web browser and go to the official MySQL downloads page. 
  2. Choose the MySQL Installer for Windows appropriate for your system. 
  3. Click Download and wait for the file to finish downloading. 
  4. Go to the official MySQL website: https://dev.mysql.com/downloads/installer/ 
  5. Choose MySQL Installer for Windows: 
  6. Web Installer (~2 MB) – downloads components as needed. 
  7. Full Installer (~400 MB) – includes all components. 

Step 2: Launch the Installer 

  1. Navigate to your Downloads folder. 
  2. Right-click the downloaded installer file and select Run as administrator (or double-click to run it). 
  3. If prompted by Windows security, click Yes to allow the installer to run 

Step 3: Choose Installation Type 

  1. When the installer opens, you will see several setup types. 
  2. Select Custom setup type to manually select what you want installed. 
  3. Click Next to continue.

Step 4: Select Products and Features 

  1. In the customization screen, confirm that MySQL Server is selected. 
  2. Once selections are complete, click Next. 

Step 5: Install Components 

  1. The installer will begin downloading the selected components. 
  2. After download, the installation process will start automatically. 
  3. Wait until all components are installed successfully. 

Step 6: Configure MySQL Server 

  1. Choose Standalone MySQL Server as the configuration type. 
  2. For system type, select Dedicated Computer if you want MySQL to use more system resources (useful for development).  
  3. Set Port Number to the default 3306 unless you have a specific need to change it.

Step 7: Security Settings 

  1. Choose the recommended authentication method. 
  2. Create a strong root password and confirm it. 
  3. Optionally, add additional MySQL users if needed. 

8: Apply Configuration 

  1. Review your configuration summary.
  2. Click Execute to apply all settings. 
  3. Wait for the process to complete — you should see green checkmarks for each step. 

Step 9: Set Environment Variables (Optional) 

  1. To run MySQL from anywhere in the Command Prompt, add the MySQL bin directory to your system PATH. 
  2. Open System Properties > Advanced > Environment Variables. 
  3. Edit the Path variable and add: 

C:\Program Files\MySQL\MySQL Server 8.0\bin
“` :contentReference[oaicite:10]{index=10}
 

Step 10: Test the Installation 

  1. Open Command Prompt and enter: mysql -u root -p
  2. Enter your root password when prompted.
  3. If you see the MySQL prompt (mysql>), the installation was successful 

 

 

 

 

Recent Posts