# h8 w' B" k8 S5 F - g6 k2 Q! U ?% {' ~6 b; M: T6 J N& g2 z
& {" n \8 ^6 _2 \
資料表(Table)八種權限:. m* s0 e' v" e0 p% x# a3 C2 G) q1 V, Z
7 _) Q1 G, |; ~3 {( z' D
2 j0 o( \1 Y/ x8 [( K8 K) m( iSELECT、INSERT、UPDATE、DELETE、CREATE、DROP、INDEX、ALTER % f. v" ?3 Z' W# r3 `/ E9 G2 Z+ `4 g9 p8 e
, q/ P$ v7 P5 v2 S/ ~$ r+ H o
$ a) {1 l2 t5 D$ W# `. }/ p$ M2 P/ o% Y+ \) V
資料欄(column)三種權限: 7 [# C& e0 ?! M8 b' v( ` # T+ e! u# w+ P. F: W- \% [: k& I/ e8 @ ?+ m
SELECT INSERT UPDATE7 G; h& |- \1 L4 p
! W6 o% R! |" q: T9 L9 N5 k$ L$ N' L* x6 m% z) \
% G/ [6 n5 D2 o1 g
【實例:】 ! e) ?2 _, P7 P5 P5 P' l* x$ M- K4 }# M W# J7 {8 \
; C l4 A- z: x' `: w, {
[root@localhost ~]# mysql -u root -p4 B* R+ l; T( e0 p
Enter password:* g7 J2 [1 c/ z% C% C' C' ]+ I
Welcome to the MySQL monitor. Commands end with ; or \g. A, w1 [* k0 l5 m+ `% B
Your MySQL connection id is 2 ! H/ {# f6 s% ~7 UServer version: 5.1.52 Source distribution8 ?0 x7 @, K% v8 e1 f: `
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. / _" w2 Z. a8 f5 \2 o |This software comes with ABSOLUTELY NO WARRANTY. This is free software, . @% e- L3 H, @1 ^9 i0 Nand you are welcome to modify and redistribute it under the GPL v2 license 2 o$ J4 q' G: I7 ]2 N& A0 A* d6 _0 q
, J/ P7 |' b) v- M* z
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement." h; L+ ^/ I5 P! A3 g. n
0 r* q2 z8 u" Z4 z" h/ G
I% f3 \3 W1 A9 n! p, e' O
mysql> grant all privileges on *.* to test@localhost identified by '1234567'; //第一個星號是database，第二個星號是table+ y8 @3 O# @0 j! m
# ?( i0 s3 Q# {5 }1 r1 q* e. F) r$ ?5 K+ n) Z+ K3 I& i
Query OK, 0 rows affected (0.00 sec) //建立test帳號本機權限1 B/ F. y6 ?7 m4 F/ F: J6 \0 m; n
4 ?% {0 ~8 i( \6 O/ \6 G0 Z
$ r8 q' k7 S" j9 C/ t0 imysql> grant all privileges on *.* to [email protected] identified by '1234567';; B! f) B& \9 L2 \7 F
# [, V8 _9 d- j8 }/ [
0 D$ E- z& X. z' GQuery OK, 0 rows affected (0.01 sec) //建立test帳號遠端權限2 Z' n9 _& i& l6 j7 Y1 I
/ m& S% d2 t7 E
5 s0 ?; \! h l2 E8 ]. t3 P' | {; l
# S, k h% P2 r2 _1 r5 @2 z m
mysql> select host,user from mysql.user; //查詢MySQL所有授權帳號 # e l3 _7 x% i6 \ p/ o1 n! e. Y2 G, \" t. c- M$ p }& ^0 ~6 v
0 a' _6 ~6 m! i+ G' o) G
+-----------------------+-------+: h6 d9 n; Y: Z. B
| host | user |" @! P* y6 d# Z5 T# R4 R5 \
+-----------------------+-------+4 F7 f0 ~. T$ p3 ^
| 127.0.0.1 | root | ( l; P: E; Z: b, x# X| 192.168.1.2 | test | //帳號test遠端授權- @ |% o- O/ G$ v
| localhost | | - ~; p: e+ h+ }# M| localhost | test | //帳號test本機授權0 A6 R5 Z2 w3 N$ p4 ]% D; {
| localhost | root | ! z" k$ f% v$ `; x8 ^: Y| localhost.localdomain | | 9 N3 K8 w1 T9 o, p) a4 r; t| localhost.localdomain | root | ) d, M0 s2 Q6 E+-----------------------+-------+1 L: W( Z! K' W: z# R8 \
7 rows in set (0.00 sec) 0 V! \5 A7 j3 G% ? + j9 n5 U" {6 i9 Z* x" q7 w5 ?. A) t
mysql> quit //離開MySQL ( `9 e; u; l0 [9 ABye + y3 f! p, _* H: a1 K4 Y0 I- R& i% s[root@localhost ~] / l2 \4 {3 H' M6 u6 J6 p9 P3 o 5 o) D# ^! y N8 fp.s 其他mysql 重要語法請參考http://mail.hmes.kh.edu.tw/~jona/redhat/mysqlphp/mysqlsyntax.htm. x( z/ w, L* q0 O5 @5 F& r
& h2 o7 ^3 ^: Z. O% ^