砍敺 IT_man 2014-12-31 09:25 蝺刻摩
+ W) A8 i! Z4 h- ^4 G2 ?5 Q
, l% m, g/ f& \% W! i隤芣2 _6 I7 m6 [! V' t+ v4 s: q
MySQL鞈摨急甈祆蝡荔靘憒嚗銝撣唾蝬摰蝯奸ocalhost閰梧閰脣董芾賢決ySQL鞈摨急祆雿輻剁閬曄策蝡臭蜓璈蝺衽ySQL鞈摨思蜓璈閰梧撠勗撠撣唾蝬摰蝯阡蝡臭蜓璈雿輻剁銝嫣蝝寞孵賣舀甈芷斗甈嚗MySQL甈敺憭臭誑銝:- t1 T q _, E( S
2 q# `. U/ r% n/ m4 J2 N+ `& h T5 {# ?/ r' T8 m% G; C
, p, C) a" v9 M q1 F鞈摨(DateBase)鈭蝔格:
) h% t& D+ C9 A" r& g1 l0 x
: R! l8 F# o5 V6 ~+ m* W& e
: c5 a) G; @& F7 w6 Y8 T6 w# B) TALL PRIVILEGESALTERCREATEDELETEDROPFILEINDEXINSERTPROCESSREFERENCESRELOADSELECTSHUTDOWNUPDATEUSAGE! m* f6 y6 |4 L7 m6 @
9 s% [5 f. a' j \+ n) L$ g1 f& Z8 \' }5 |) g
! o; L1 X8 z& \5 ~; j% p
+ E$ Z+ Y. A, T2 I1 C' V
鞈銵(Table)怎車甈:- [" L" U0 h+ ?+ }
0 P) t" |% ^9 g( W: T7 m m
c& E5 Y' f+ V e) V# N6 SSELECTINSERTUPDATEDELETECREATEDROPINDEXALTER
+ I: e/ T3 L. \* W2 f& u3 A! Q" e I' z/ n; g H4 H
5 \8 N3 h3 j. }$ N0 P; c, V& O* y) J9 v2 L$ T4 i
* V$ ~0 r% {( G) s
鞈甈(column)銝蝔格:0 D! \- [* Y/ f$ {% o3 F d" E
3 E) l$ U" y+ o/ x. D! `, R2 J5 M- m. B( _
SELECT INSERT UPDATE
2 t' b0 h8 [$ ~! l& Z" e+ {; j# Z) l% q7 C6 e# R
+ f8 n% R1 d; x2 [" B: n# C' o8 b8 g8 B
撖虫:, V4 A) J7 V# T, ]7 S
4 Q, y @* `5 n. \7 t% c5 f& m8 F& Q5 f5 p8 p7 r) n
[root@localhost ~]# mysql -u root -p
( @, Y- U1 |; h4 A* O+ G9 PEnter password:* S8 P" _2 N' |0 ]
Welcome to the MySQL monitor. Commands end with ; or \g.
' a7 f' Y) c5 s% B& rYour MySQL connection id is 2
7 Q( Y- Q8 \! c F XServer version: 5.1.52 Source distribution
% B4 b" h6 {( B/ RCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
% A/ f3 y1 I; JThis software comes with ABSOLUTELY NO WARRANTY. This is free software,. v$ m2 e+ q2 r, O# @9 V2 Y
and you are welcome to modify and redistribute it under the GPL v2 license7 \3 @0 f* \( b. H
5 B/ t' s5 ]8 p* X9 M
l# V: p% `. K9 jType 'help;' or '\h' for help. Type '\c' to clear the current input statement., x5 u; |: t& z& E% @( H
- E! J& {; F% z4 R4 @# S& P$ L
9 {3 E( w$ X! g( n# w# g1 umysql> grant all privileges on *.* to test@localhost identified by '1234567'; //蝚砌留atabase嚗蝚砌眩able: I7 }& J3 ~* Z0 J- q
/ c6 R8 M. K1 {- `6 S
/ M- @3 v6 d; y" q4 a. {0 {Query OK, 0 rows affected (0.00 sec) //撱箇test撣唾祆甈. M- V2 u1 Q# b" h* A8 s+ }2 q
5 Q1 {9 s' a! h! Z) j! A. i8 v0 u! B' {$ Y" m1 f0 ?9 s- T
mysql> grant all privileges on *.* to test@192.168.1.2 identified by '1234567';
! f- ~9 a, S7 ~+ k, \2 r% P
& v& C& r' n* w/ }7 B( K1 i( l
; m7 E, R" d3 TQuery OK, 0 rows affected (0.01 sec) //撱箇test撣唾蝡舀
2 `2 o9 O3 M# a. F+ X; T1 [
- S$ A8 l c. ~
2 o& f1 @: L* S3 ?8 k x% f0 B( H: L
mysql> select host,user from mysql.user; //亥岷MySQL甈撣唾
$ ]) \( [9 ]4 K" f: z5 q- ~# \ e: ^+ R$ ? k6 V; {" T' D
! J6 K* v/ t7 ]; ^! k' S
+-----------------------+-------+9 j) }* c5 B6 R) L( @: F2 x
| host | user |
1 T; }8 b! A. z: `: f* {6 U y6 c+-----------------------+-------+) h7 S) a/ W+ q1 J; ~5 W( N, q- ^
| 127.0.0.1 | root |, c+ ?" h! G+ o
| 192.168.1.2 | test | //撣唾test蝡舀甈# l. u5 a8 R% l- E% r* k
| localhost | |
5 j. a7 G- s, n| localhost | test | //撣唾test祆甈
) p0 l+ H3 D6 P1 t& r| localhost | root |/ l, v9 V3 d% }6 r: q4 C) _; i
| localhost.localdomain | |
& ^6 ^$ l5 M: N| localhost.localdomain | root |' i$ E% L" {# C7 a2 b3 @+ B' i- }1 \
+-----------------------+-------+1 Z. N9 G* T8 h3 B3 z
7 rows in set (0.00 sec)
2 U1 N. T* N! c( \: i8 \
. t( j$ S* U( Z: l: K6 ?) W8 I) \' a
mysql> quit //ａMySQL! b1 o5 N5 m1 H# p' E. t
Bye/ e% w* C9 D: k% p
[root@localhost ~]
: G; r4 G, U7 b5 [8 M% z0 O! W. H1 e B0 N& c3 g
p.s 嗡mysql 閬隤瘜隢http://mail.hmes.kh.edu.tw/~jona/redhat/mysqlphp/mysqlsyntax.htm
8 M% f6 o! X E2 ]4 }$ H1 ]4 ^8 U1 G
3 I; _+ B! L* I( q/ B$ ^2 B8 Y3 ` X
|
|
潸” 2014-12-31 08:01:47
嗉
鈭
霈
