[1] 選擇安裝類型：`Developer Default`
[2] 檢查依賴項(xiàng)：自動(dòng)安裝必要組件
[3] 配置認(rèn)證方式：`Use Strong Password Encryption`
[4] 設(shè)置root密碼：需包含大小寫字母+數(shù)字
[5] 配置服務(wù)名稱：保持默認(rèn)`MySQL80`

# 添加至Path環(huán)境變量
C:\Program Files\MySQL\MySQL Server 8.0\bin

mysql --version
# 預(yù)期輸出：mysql  Ver 8.0.xx for Win64 on x86_64

sudo /usr/local/mysql/support-files/mysql.server start    --啟動(dòng) MySQL
sudo /usr/local/mysql/support-files/mysql.server stop     -- 停止MySQL
sudo /usr/local/mysql/support-files/mysql.server restart  --重啟 MySQL

mysql -u root -p 或  /usr/local/mysql/bin/mysql -u root -p  -- 進(jìn)入默認(rèn)用戶：root

CREATE DATABASE school;
USE school;

CREATE TABLE students (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  score DECIMAL(5,2),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 插入數(shù)據(jù)
INSERT INTO students (name, score) VALUES ('張三', 92.5);
-- 查詢數(shù)據(jù)
SELECT * FROM students WHERE score > 90;
-- 更新數(shù)據(jù)
UPDATE students SET score = 95.0 WHERE name = '張三';
-- 刪除數(shù)據(jù)
DELETE FROM students WHERE id = 1;

SHOW DATABASES;        -- 查看數(shù)據(jù)庫列表
DROP DATABASE  text;   -- 刪除指定 數(shù)據(jù)庫，如：text
DESC students;         -- 查看表結(jié)構(gòu)

- MySQL Workbench (官方工具)
- Navicat for MySQL
- DBeaver (開源免費(fèi))

CREATE USER 'teacher'@'localhost' IDENTIFIED BY 'SecurePass123!';
GRANT SELECT, INSERT ON school.* TO 'teacher'@'localhost';
FLUSH PRIVILEGES;

mysqldump -u root -p school > school_backup.sql

mysql -u root -p school < school_backup.sql