. U/ W9 d5 A4 z: V. f【說明】/ c8 ?; x$ z0 w
MySQL資料庫授權有分成本機及遠端,例如,一個帳號綁定給localhost的話,那該帳號只能在MySQL資料庫本機使用,要開放給遠端主機連線到MySQL資料庫主機的話,那就必須將帳號綁定給遠端主機使用,下方介紹方式都是授權或刪除所有權限,MySQL權限有很多可以參考下列: 3 a- g3 `* z+ G s: p * ~2 a6 F2 K) w6 x, G ' T( F: k7 P l4 p8 R7 Z+ x9 t( h; y- B& h3 Z& ]. k1 _0 e
資料庫(DateBase)十五種權限:& C ^/ J( v; K" t
) T5 ?' U# K: g8 o- Y0 v+ K8 j. V" O. w
ALL PRIVILEGES、ALTER、CREATE、DELETE、DROP、FILE、INDEX、INSERT、PROCESS、REFERENCES、RELOAD、SELECT、SHUTDOWN、UPDATE、USAGE) o( }$ T, v2 e8 s
" `$ [; m4 y- y( e
+ Z, b; p) z8 T8 W& n H. W, Z8 u1 ^! K; x: ~
0 W+ P: v' l$ H
資料表(Table)八種權限:! e4 D; u+ E- A- y! W0 B
6 Q* L. [: p5 X, E' _ & Y7 j' |: A) P; {, M【實例:】 3 B* X* w' e2 ~3 [& w ( t, M6 i* z, Z/ p( s; a# E& r( k0 C; u' e9 L
[root@localhost ~]# mysql -u root -p . G8 J' N" P/ y6 `. _2 LEnter password:! P7 b2 p. R$ t8 }5 V
Welcome to the MySQL monitor. Commands end with ; or \g.6 {& K; V6 W9 B+ ^
Your MySQL connection id is 2; r6 Y3 i ~1 g$ X4 }" b! _
Server version: 5.1.52 Source distribution 0 \$ O6 S- f# iCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.4 H& {% z8 h- }' Q c
This software comes with ABSOLUTELY NO WARRANTY. This is free software, 7 b9 T2 i8 r# ^1 e& P; Wand you are welcome to modify and redistribute it under the GPL v2 license) v! }2 a8 u% `4 F+ {
$ p8 |0 M7 K' p3 }& J. Y" d
; v: r; H1 z+ d+ u, Z" y
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.- N* B8 ~9 W+ d7 n, Y* S8 n
! b6 V+ P# N X1 p" `# o
% j- A) F( {; {2 W: e: Hmysql> grant all privileges on *.* to test@localhost identified by '1234567'; //第一個星號是database,第二個星號是table \4 w3 j7 f7 P L; m. K( c& ? . u0 W4 j" S# a7 q" b2 V, R: @ ; F* w& }; t) }4 D' cQuery OK, 0 rows affected (0.00 sec) //建立test帳號本機權限! i% \4 m$ c# I5 h6 O6 g: Q: T
+ E, E1 y0 [5 B- a- h) j d4 ~ {, S & ]2 l' ]5 R/ ?( Ymysql> grant all privileges on *.* to [email protected] identified by '1234567'; & D6 x6 q# w# T* i' P' o2 F1 a 7 F3 M9 e1 S- i1 m5 C& ?5 p$ T1 F" K" T) Q, x( P
Query OK, 0 rows affected (0.01 sec) //建立test帳號遠端權限 * I; }' n* O3 z& n( F6 h4 M: T
! h9 Y8 _7 \! p% h