Installation Tutorial

Installation

This section covers the detailed steps for installing MySQL 8.4 on Windows, macOS, and Linux. Each subsection will offer a clear explanation, practical examples, and step-by-step instructions, along with post-installation setup.

Installing MySQL 8.4 on Windows

Step 1: Download MySQL Installer

Go to the MySQL Downloads page:
- Navigate to the MySQL official website at https://dev.mysql.com/downloads/installer/.
Select the MySQL Installer:
- Choose the MySQL Installer for Windows and download the mysql-installer-web-community-8.4.x.msi file.

Step 2: Run the Installer

Open the Installer:
- Double-click the downloaded .msi file to launch the installer.
Setup Type:
- You will be prompted to select a setup type. Choose Custom to customize the components you need or Developer Default for a comprehensive setup.

Step 3: Installation

Select Products and Features:
- Ensure that MySQL Server, MySQL Workbench, and other desired components are selected.
Check Requirements:
- The installer will check for any missing requirements. Install any necessary software, such as Visual C++, if prompted.
Installation Progress:
- Click Execute to begin the installation of the selected components.

Step 4: Initial Configuration

Configuration Type:
- Choose the Standalone MySQL Server / Classic MySQL Replication option.
Server Configuration:
- Set the Config Type to Development Computer, Server Computer, or Dedicated Computer, based on your needs.
- Choose the Connectivity options such as default port 3306.
Authentication Method:
- Select Use Strong Password Encryption for enhanced security.
MySQL Root Password:
- Set a strong root password and add any additional MySQL users if necessary.
Windows Service:
- Ensure that Configure MySQL Server as a Windows Service is checked. Optionally, set the service to start automatically.

Step 5: Complete Installation

Execute Configuration:
- Click Execute to apply the configuration settings.
Finish:
- Once the installation and configuration are complete, you will see a summary. Click Finish.

Installing MySQL 8.4 on macOS

Step 1: Download MySQL DMG Archive

Go to the MySQL Downloads page:
- Navigate to https://dev.mysql.com/downloads/mysql/.
Select macOS:
- Choose macOS and download the dmg file for MySQL 8.4.

Step 2: Install MySQL

Open DMG File:
- Double-click the downloaded .dmg file to mount it.
Run the Installer:
- Double-click the mysql-8.4.x-macos10.x-x86_64.pkg file.
Follow Installer Steps:
- Follow the onscreen instructions in the install wizard.
Authentication:
- During installation, you may be prompted to enter your macOS password to authorize the installation.

Step 3: Initial Configuration

MySQL Preference Pane:
- After installation, a MySQL preference pane will be added to System Preferences.
Start MySQL Server:
- Open System Preferences -> MySQL and click Start MySQL Server.
Set Up Root Password:
- During initial startup, you will be prompted to set the root password.

Step 4: Add MySQL to System Path (Optional)

Edit Profile:
- Open Terminal and edit your profile file (~/.bash_profile or ~/.zshrc, depending on your shell).
Add Path:
- Add the following line:
```
export PATH=/usr/local/mysql/bin:$PATH
```
Apply Changes:
- Source the profile by running:
```
source ~/.bash_profile
```

Installing MySQL 8.4 on Linux

Step 1: Update Package Repository

Open Terminal:
- Open your terminal window.
Update Package Lists:
- Run the following command to update your package lists:
```
sudo apt update
```

Step 2: Install MySQL

Add MySQL APT Repository:

Download the MySQL APT repository package:

wget https://dev.mysql.com/get/mysql-apt-config_0.8.17-1_all.deb

Install the MySQL APT config package:

sudo dpkg -i mysql-apt-config_0.8.17-1_all.deb

Update Package Lists Again:
- Run:
```
sudo apt update
```
Install MySQL Server:
- Install MySQL server:
```
sudo apt install mysql-server
```

Step 3: Secure MySQL Installation

Run Security Script:
- Execute the following command to run the security script:
```
sudo mysql_secure_installation
```
Follow Prompts:
- Follow the prompts to set the root password, remove anonymous users, disallow root login remotely, remove test databases, and reload privilege tables.

Step 4: Start MySQL Service

Start Service:
- Ensure the MySQL service is running:
```
sudo systemctl start mysql
```
Enable Service to Start at Boot:
- Enable MySQL to start on boot:
```
sudo systemctl enable mysql
```

Post-Installation Setup

Regardless of your operating system, after installing MySQL 8.4, you should perform the following post-installation setup:

Step 1: Verify Installation

Open Terminal or Command Prompt:
- Open your terminal (Linux/macOS) or Command Prompt (Windows).
Log in to MySQL:
- Log in to MySQL using the root user:
```
mysql -u root -p
```
Check Version:
- Verify the MySQL version:
```
SELECT VERSION();
```

Step 2: Create a Database and User

Create Database:
- Create a new database:
```
CREATE DATABASE mydatabase;
```

Create User:

Create a new user and grant privileges:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;

Step 3: Exit MySQL

Exit:
- Exit the MySQL command line:
```
EXIT;
```

By following these detailed steps, you will have MySQL 8.4 installed and set up on your Windows, macOS, or Linux system, ready for further configuration and use.

MySQL 8.4 Tutorial