第一招：服務啟動與停止 (Windows)

net stop mysql
net start mysql

第二招：登入 MySQL

mysql -u root -p
# 輸入密碼後進入 mysql> 提示符
# 遠程：mysql -h 192.168.1.100 -u root -p

第三招：創建用戶與授權

-- 本地全權限
GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO 'user1'@'localhost' IDENTIFIED BY 'password1';

-- 遠程訪問
GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO 'user1'@'%' IDENTIFIED BY 'password1';

-- 無密碼賬號(不推薦)
GRANT SELECT, INSERT, UPDATE, DELETE ON `mydb`.* TO 'user1'@'localhost' IDENTIFIED BY '';

第四招：庫表核心操作

SHOW DATABASES;
USE mysql;
SHOW TABLES;
DESCRIBE user;

CREATE DATABASE dbname;
DROP DATABASE dbname;

USE dbname;
CREATE TABLE tbl (id INT PRIMARY KEY, name VARCHAR(20));
DROP TABLE tbl;

DELETE FROM tbl;          -- 清空數據
TRUNCATE TABLE tbl;       -- 更快，重置自增ID
SELECT * FROM tbl;

第五招：導出與導入數據

mysqldump 導出

# 單庫
mysqldump --opt test > mysql.test

# 指定用戶密碼、多庫
mysqldump -u root -p'123456' --databases dbname > mysql.dbname

mysqlimport / 重定向導入

mysqlimport -u root -p'123456' < mysql.dbname
# 或
mysql -u root -p dbname < backup.sql

文本文件導入 (LOAD DATA)

USE test;
LOAD DATA LOCAL INFILE 'data.txt' INTO TABLE tbl_name;
-- 字段 Tab 分隔，NULL 用 \N