, m U* f* [5 W2 F$ @' i資料庫(DateBase)十五種權限: 9 ^; B. i- G8 {5 [6 }7 A * B1 F8 A! d \# T4 W% M* y7 w9 G+ g7 g0 g0 F6 B3 b1 V
ALL PRIVILEGES、ALTER、CREATE、DELETE、DROP、FILE、INDEX、INSERT、PROCESS、REFERENCES、RELOAD、SELECT、SHUTDOWN、UPDATE、USAGE / J" D3 `+ C) c4 A 3 S- o m, U! G$ ^, c/ i1 |& h9 @# o# J( n6 Y7 @
& A1 v g. r4 A* H2 }% @" s! d
" J# E& P) J$ v; } ]& G5 V- c( Q
資料表(Table)八種權限: 3 A R4 U: V: }! N# s$ |+ ~5 B J # F9 V6 c$ k% o" L, u- z) u2 v+ p7 i* w) v- m- j& o# {- f
SELECT、INSERT、UPDATE、DELETE、CREATE、DROP、INDEX、ALTER $ P9 n& B3 c# w. t 5 i2 v1 Y) C6 c$ u; E0 U2 e, p; l0 f6 I1 b
) t/ ?8 G9 U' x! [/ B / X" c$ l( G b$ V5 M+ @5 w資料欄(column)三種權限:5 c( F7 ^2 k5 ]. c/ R8 X/ A- o4 d0 ?- U
! J p" K8 I; L3 Z \3 \/ i
. k: ]; b0 y; k% `1 ]7 I
SELECT INSERT UPDATE7 N& ?8 I$ m/ M/ C* ~: y% Q+ c
5 ^, O3 R. F5 z' F2 q4 j * {' l* J2 r. {/ [4 v6 D ' D% S% N9 x" g9 `6 j. T【實例:】6 }6 w" `: \* B8 L) f* _
6 `+ H; a. l' y$ I* T, E+ M$ ]& F9 m/ _/ s1 I6 z" v l$ c+ s
[root@localhost ~]# mysql -u root -p 2 D3 B5 ~5 P1 w4 o9 d7 ^Enter password: 7 L5 |/ d/ m: d9 }, ^4 ]Welcome to the MySQL monitor. Commands end with ; or \g.9 i( R$ h$ M& D v8 m4 h
Your MySQL connection id is 2 ' r/ x8 D8 u+ d' U, \- sServer version: 5.1.52 Source distribution % i( H! g# Z& G/ m+ VCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved., m, A2 [# v$ H: q0 R: z* k
This software comes with ABSOLUTELY NO WARRANTY. This is free software, & @3 o$ p, _/ |- D) ]and you are welcome to modify and redistribute it under the GPL v2 license, A! v# h1 D/ }4 s# ^
1 ^+ j3 u/ H3 ?5 d8 f% c & ~+ ]8 c3 c5 O' JType 'help;' or '\h' for help. Type '\c' to clear the current input statement.1 m6 p4 M- L! W6 o9 c. t/ G5 s
! C1 h' }4 V3 y& l p$ x+ ~0 D
: z. S1 j# I* N# [' w( Rmysql> grant all privileges on *.* to test@localhost identified by '1234567'; //第一個星號是database，第二個星號是table; L: j1 E; `* p3 X( D* J9 k+ E
6 n, O0 o5 f6 ?3 C! T2 E8 v+ o: b
Query OK, 0 rows affected (0.00 sec) //建立test帳號本機權限 2 Y o1 G' ~( i* Y1 N* |2 B : P8 F8 d6 _0 i' R 7 n% }0 ]: z" j" `% lmysql> grant all privileges on *.* to [email protected] identified by '1234567'; 5 z$ U7 u& l+ `/ _9 z6 y" d ~; e3 d& ^
, l" }' _! o& O V4 oQuery OK, 0 rows affected (0.01 sec) //建立test帳號遠端權限) ^- s/ z1 r, x) ^4 ]- X6 E* x8 ^& d
0 B: x: F1 }+ C: E6 A+ r" p
" y' C7 E0 c! _* X & B) W9 z# V, q1 k# Hmysql> select host,user from mysql.user; //查詢MySQL所有授權帳號5 L, b9 c3 i3 x' T
/ \6 _' O# L, \4 V6 v6 d& y ' }4 ?2 K* a) B5 ]+-----------------------+-------+3 G$ E5 s" Z( c. W, b+ v( {/ r; l2 L2 g
| host | user | * x; f0 J& k5 g, i) Z1 v0 I+ o+-----------------------+-------+ 6 Y; W6 J7 a0 I7 q ^ A| 127.0.0.1 | root |2 x5 v! Q* D5 w* `- H' h
| 192.168.1.2 | test | //帳號test遠端授權 , G' q$ V& r) n* c U5 Y: m$ B# w ]| localhost | |2 O2 o5 m4 n/ ]) m* q {8 T1 H
| localhost | test | //帳號test本機授權& T/ O9 ^; ]* o$ ~/ V S" u
| localhost | root |8 Z- L- _3 M# J! Z6 o
| localhost.localdomain | |- f* D7 j$ v; g3 L0 ~8 V' ?3 `2 S
| localhost.localdomain | root |' o% ]$ w4 i2 V% D
+-----------------------+-------+ ! m# s: M! _2 G7 i$ R7 rows in set (0.00 sec)( o5 j: q! |; x
5 J4 N4 I/ Y! }, f
# U0 C3 E+ ^- V+ v" Y% H4 z8 ~
mysql> quit //離開MySQL5 k1 s5 Z# k) j+ n9 R8 s4 L
Bye1 g( I- P, l8 Y8 o
[root@localhost ~] 6 X9 V0 ?. A K p4 h" y, W. l1 z1 B: t! H
p.s 其他mysql 重要語法請參考http://mail.hmes.kh.edu.tw/~jona/redhat/mysqlphp/mysqlsyntax.htm # K; Z& W" ?4 V1 b- J8 _0 N3 D+ f4 a e7 s4 Z$ O- ]' R