MYSQL Tutorial

⚙️ Installation and Setup of MySQL

To use MySQL, you must install the MySQL Server and a client tool to manage your databases.

🪟 Windows Installation

1. Go to the official MySQL website: dev.mysql.com/downloads/installer
2. Download the MySQL Installer for Windows (Community).
3. Run the installer and choose:
   • Developer Default – recommended for beginners.
4. Click Next and install required software (if prompted).
5. Set a strong root password (remember this!).
6. Click Execute and wait for installation to finish.

🍏 macOS Installation

1. Install Homebrew (if not already installed).
2. Run the command:
   

   brew install mysql

3. Start MySQL server:
   

   brew services start mysql

4. Log in to MySQL:

   mysql -u root

🐧 Linux (Ubuntu) Installation

1. Update your packages:

   sudo apt update

2. Install MySQL Server:

   sudo apt install mysql-server

3. Secure the installation:

   sudo mysql_secure_installation

4. Log in:

   sudo mysql

📌 Tools to Use with MySQL

• 🖥️ MySQL Command Line – built-in terminal for running queries.
• 🧰 MySQL Workbench – GUI tool for creating tables and writing SQL visually.
• 🧪 phpMyAdmin – web-based tool for managing MySQL (use with XAMPP).