🐬Installing Started with MySQL
Getting Started with MySQL and MySQL Workbench Installation
Overview
This guide will help you set up MySQL for your development environment. Additionally, you have the option to install MySQL Workbench, a powerful tool for managing your MySQL databases. Follow these steps to get started with MySQL.
📊SQL ServerPrerequisites
A computer running Windows, macOS, or Linux
Administrator privileges for installing software
Step 1: Install MySQL Server
Windows
Download MySQL Installer:
Go to the MySQL Community Downloads page.
Click on "MySQL Installer for Windows" and download the installer.
Run the Installer:
Open the downloaded installer.
Choose the setup type (Developer Default is recommended).
Follow the on-screen instructions to complete the installation.
Configure MySQL Server with a root password and set up any other required configurations.
Verify Installation:
Open Command Prompt.
Run the following command to verify the installation:
You should see the installed version of MySQL.
macOS
Download MySQL DMG Archive:
Go to the MySQL Community Downloads page.
Select macOS as your operating system and download the DMG archive.
Install MySQL:
Open the downloaded
.dmg
file.Run the MySQL installer package.
Follow the on-screen instructions to complete the installation.
Configure MySQL Server with a root password during the installation process.
Start MySQL Server:
Open System Preferences and go to MySQL.
Start the MySQL server.
Verify Installation:
Open Terminal.
Run the following command:
You should see the installed version of MySQL.
Linux
Add MySQL APT Repository:
Open Terminal and run the following commands (for Ubuntu/Debian-based distributions):
Install MySQL Server:
Run the following command:
During the installation, you will be prompted to set a root password.
Start MySQL Server:
Ensure MySQL server is running:
Verify Installation:
Run the following command:
You should see the installed version of MySQL.
Step 2: Install MySQL Workbench (Optional)
Windows
Download MySQL Workbench:
Go to the MySQL Workbench Downloads page.
Select the appropriate version for Windows and download the installer.
Run the Installer:
Open the downloaded installer.
Follow the on-screen instructions to complete the installation.
Launch MySQL Workbench:
Open MySQL Workbench from the Start Menu or Desktop.
macOS
Download MySQL Workbench:
Go to the MySQL Workbench Downloads page.
Select the appropriate version for macOS and download the DMG archive.
Install MySQL Workbench:
Open the downloaded
.dmg
file.Drag the MySQL Workbench icon to the Applications folder.
Launch MySQL Workbench:
Open MySQL Workbench from the Applications folder.
Linux
Download MySQL Workbench:
Go to the MySQL Workbench Downloads page.
Select the appropriate version for your Linux distribution and download the package.
Install MySQL Workbench:
For Ubuntu/Debian-based distributions, use the following commands:
Launch MySQL Workbench:
Open MySQL Workbench from the applications menu or run
mysql-workbench
from the terminal.
Last updated