Menu
MySQL

Installing MySQL

Installing MySQL depends on the operating system you're using. Below are instructions for installing MySQL on different operating systems:

 

1. Installing MySQL on Windows

Download MySQL Installer:

  • Visit the MySQL Downloads page.
  • Download the "MySQL Installer for Windows" (preferably the full package).

Run the Installer:

  • Open the downloaded '.msi' file to launch the MySQL Installer.
  • Installs MySQL Server, MySQL Workbench, and other developer tools.

Configure MySQL Server:

  • Set up MySQL as a service (recommended).
  • Choose the configuration type (typically Standalone MySQL Server).
  • Set a root password and optionally create a new MySQL user.

Complete the Installation:

  • Once the configuration is done, proceed with the installation.
  • After installation, you can start MySQL Workbench to manage the database.

 

 

2. Installing MySQL on macOS

Download MySQL:

Install MySQL:

  • Open the downloaded '.dmg' file and follow the installation instructions.
  • During installation, you'll be prompted to set a root password.

Start MySQL Server:

  • After installation, MySQL should be available in System Preferences.
  • You can start or stop the MySQL server from there.

Add MySQL to System Path (optional):

  • You may want to add MySQL to your system path to use it easily from the terminal:
echo 'export PATH="/usr/local/mysql/bin:$PATH"' >> ~/.bash_profile
source ~/.bash_profile

 

Manage MySQL:

  • You can use MySQL Workbench (downloadable from the MySQL site) to manage your databases.

 

 

3. Installing MySQL on Linux:

Update the Package Index:

  • Open a terminal and run:
sudo apt update

 

Install MySQL Server:

  • Install MySQL by running:
sudo apt install mysql-server

 

Secure MySQL Installation:

  • Run the security script to remove insecure defaults:
sudo mysql_secure_installation
  • Follow the prompts to set a root password and secure your MySQL installation.

 

Start MySQL Service:

  • Ensure that the MySQL service is running:
sudo systemctl start mysql
  • Enable MySQL to start on boot:
sudo systemctl enable mysql

 

Access MySQL:

  • Log in to MySQL with the root user:
sudo mysql -u root -p
  • Enter the password you set during the installation.

 

MySQL