/ ?3 `- C7 e$ [1 J) C Y% q【說明】, T; W0 Y# o! h1 ~# T- q6 D( l
MySQL資料庫授權有分成本機及遠端，例如，一個帳號綁定給localhost的話，那該帳號只能在MySQL資料庫本機使用，要開放給遠端主機連線到MySQL資料庫主機的話，那就必須將帳號綁定給遠端主機使用，下方介紹方式都是授權或刪除所有權限，MySQL權限有很多可以參考下列:) a) _2 Y! c( Y% k/ {6 B
7 r4 L' l, N/ U) j- {4 Q ; m6 U; _; d; F4 D6 A/ N. l# X. o 6 f# }$ v0 n6 g3 B1 O: G2 E. N1 J8 n資料庫(DateBase)十五種權限:1 T; `+ w& g* O6 j
- @3 u( u6 ?7 T, l2 R' \8 P) J7 O' `4 l9 h" J6 g) }0 s: [
ALL PRIVILEGES、ALTER、CREATE、DELETE、DROP、FILE、INDEX、INSERT、PROCESS、REFERENCES、RELOAD、SELECT、SHUTDOWN、UPDATE、USAGE' O. _/ ]1 M* g2 D
) x4 S. c1 P. z
( n+ G4 \/ z( }3 Z1 ^ + s) d. X4 X }( L5 X1 Y& ]+ S5 G T& v4 l# S4 [+ T5 i4 D
資料表(Table)八種權限: 7 O; x5 x* W# V' A4 r3 F( v2 d . E7 Q. v7 ?. U# [( m( Q8 X; y1 g" K" p
SELECT、INSERT、UPDATE、DELETE、CREATE、DROP、INDEX、ALTER% b3 Z' e( ~: w$ V
$ @! J H9 s) g0 G- V o# {% @2 Q* \4 \ 5 }! q% ` f d# Y; P' k# Q6 L. T3 L3 d# \8 U7 G. v/ L0 w
) P. n% B6 }1 k0 M$ o【實例:】+ H* B, m* S, s+ R. k1 m3 v
6 M1 m/ \# `) {1 F
; K7 o6 q2 j7 j. o4 v[root@localhost ~]# mysql -u root -p ! d* k) \; p0 p1 p5 O! C) b% kEnter password:6 T3 c) f+ ~) l9 E0 J5 E" J
Welcome to the MySQL monitor. Commands end with ; or \g. . p c5 j4 t c# _* H8 |) SYour MySQL connection id is 24 M+ f6 ]& R1 _
Server version: 5.1.52 Source distribution/ g# n; P, K. h
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. 2 Q# \3 D% a+ W, I& b F7 NThis software comes with ABSOLUTELY NO WARRANTY. This is free software, 0 X; I/ i+ i8 ^7 {4 R2 }and you are welcome to modify and redistribute it under the GPL v2 license 6 x; p& i. C5 @5 q# S, P( [( U3 ?: Y }, O V
; i/ J9 R' {3 K* ~5 g4 d) S# z
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 2 P8 I+ m. e! @1 Z, a/ |+ K; o+ Z$ W9 A7 S
) [% {/ B( d5 Z* i, F" p7 @
mysql> grant all privileges on *.* to test@localhost identified by '1234567'; //第一個星號是database，第二個星號是table : v# l2 j9 c$ H2 n( i6 c" I v) t6 f$ B- G' ^# \2 g
0 R# T; X, n7 b9 f( j) v# b2 g; N
Query OK, 0 rows affected (0.00 sec) //建立test帳號本機權限0 p. C3 d7 j6 L; ^9 ~/ h; |
1 @- `4 l3 z' q+ ?2 J* d# w( L
mysql> grant all privileges on *.* to test@192.168.1.2 identified by '1234567'; $ [; ~% m- M+ x n/ ~ N/ m/ P E# Y6 C7 U5 P 8 |8 j" R, U1 Q7 j, `Query OK, 0 rows affected (0.01 sec) //建立test帳號遠端權限$ z* ?8 b x" G$ _7 b
. Q, F; n3 Z& q$ o$ A
* ?2 ^8 ^2 I2 _# R# O, E: [( ?2 d1 p; R: c
mysql> select host,user from mysql.user; //查詢MySQL所有授權帳號 4 l, M2 i" c3 ~* g# d3 i 5 u( y) T3 R6 `7 @/ P6 [ . ^; ?; Z, \- T" T3 ~+-----------------------+-------+ 4 D# |0 ]# l& L- Y| host | user | + p, B& ]/ _; ~/ J+-----------------------+-------+ " }3 F. w7 M) K5 f- g* [$ {| 127.0.0.1 | root | $ k3 m7 Q9 r- z, o. x& \ H1 ^, q| 192.168.1.2 | test | //帳號test遠端授權 , u4 e6 T4 D9 ]' T X| localhost | |* Z' c' B: ~# E; w
| localhost | test | //帳號test本機授權' S4 s, {5 K5 U8 |+ b, O
| localhost | root | / ~8 h: }: e8 y) g| localhost.localdomain | | 1 t; u( k4 w% E; E$ V| localhost.localdomain | root | , Y8 I5 `& Q0 _0 _: @% Z9 I o+-----------------------+-------+ 9 \3 h8 w$ S7 l( X# k* C7 rows in set (0.00 sec)" `( x2 T" X+ ^- h) W' q# J
' R! q) @1 @/ M7 k( O. e' c9 R
2 K4 ]1 [2 A$ u8 _
mysql> quit //離開MySQL % q4 C( V3 b; Z" c- rBye6 }1 p8 o' p( g' l/ H* L* Z
[root@localhost ~]- a) a1 N7 E( P7 g7 T