D:\mysql\mysql-5.6.24-win32）。[mysql] default-character-set=utf8 [mysqld] port=3306 basedir=D:\mysql\mysql-5.6.24-win32 datadir=D:\mysql\mysql-5.6.24-win32\data max_connections=200 character-set-server=utf8 default-storage-engine=INNODB
MYSQL_HOME=D:\mysql\mysql-5.6.24-win32Path 追加 ;%MYSQL_HOME%\bincd /d %MYSQL_HOME%\bin mysqld --install net start mysql
mysql -u root -p
UPDATE mysql.user SET password=PASSWORD('123456') WHERE user='root';
FLUSH PRIVILEGES;
| 操作 | SQL 範例 |
|---|---|
| 創建用戶（僅本地） | INSERT INTO mysql.user(Host,User,Password) VALUES('localhost','app',PASSWORD('pwd')); |
| 創建用戶（允許遠程） | CREATE USER 'app'@'%' IDENTIFIED BY 'pwd'; (5.7+) |
| 授權（單庫全權） | GRANT ALL ON mydb.* TO 'app'@'localhost' IDENTIFIED BY 'pwd'; |
| 授權（指定權限） | GRANT SELECT,INSERT ON mydb.* TO 'app'@'%' IDENTIFIED BY 'pwd'; |
| 授權（所有庫） | GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'app'@'%' IDENTIFIED BY 'pwd'; |
| 刷新權限 | FLUSH PRIVILEGES; |
| 修改密碼 | UPDATE mysql.user SET password=PASSWORD('new') WHERE user='app' AND host='localhost'; FLUSH PRIVILEGES; |
| 刪除用戶 | DROP USER 'app'@'%'; DROP USER 'app'@'localhost'; (5.7+)或 DELETE FROM mysql.user WHERE user='app'; FLUSH PRIVILEGES; |
SHOW DATABASES; USE db_name; SHOW TABLES; DESC table_name; DROP DATABASE db_name; DROP TABLE table_name;
CREATE USER，需直接操作 mysql.user 表；5.7+ 推薦用原生語法。Host='%' 不包含 localhost（127.0.0.1），本地連接需單獨授權。
