52AV璈A|52AV.ONE

 曉撖蝣
 蝡唾酉
敹急瑕
  • av隢憯BBS
  • 璈A
  • 芣瑟憭瘚
  • 鞎澆
  • 52av鋆貉摰
  • 銝剜-銝剖銝餅
     
亦: 4626|敺: 0
銝銝銝駁 銝銝銝駁

[蝬脤隡箸沘 [mysql]甈閮剖(恍蝡臬)

[銴鋆賡包
頝唾唳摰璅撅
璅銝
潸” 2014-12-31 08:01:47 | 芰閰脖 撣 |摨閬 |梯璅∪
砍敺 IT_man 2014-12-31 09:25 蝺刻摩 , y" l& y  G( ^7 d/ X& v
7 ]% R  n% l% v( a$ Z9 U! X
隤芣
' j9 R$ X* m7 WMySQL鞈摨急甈祆蝡荔靘憒嚗銝撣唾蝬摰蝯奸ocalhost閰梧閰脣董芾賢決ySQL鞈摨急祆雿輻剁閬曄策蝡臭蜓璈蝺衽ySQL鞈摨思蜓璈閰梧撠勗撠撣唾蝬摰蝯阡蝡臭蜓璈雿輻剁銝嫣蝝寞孵賣舀甈芷斗甈嚗MySQL甈敺憭臭誑銝:
3 L) a$ p1 A2 \2 b8 ~: L) W/ ^0 W/ |) ^/ _- f" s

3 W; @+ z& ^% S  y1 C
- S% b1 C& H+ r: V" A
鞈摨(DateBase)鈭蝔格:
% f, D8 ]) ~, A& }! l- v. f
2 A% ^4 y( z4 Z6 ^
1 y% {0 d. y' D# X" n
ALL PRIVILEGESALTERCREATEDELETEDROPFILEINDEXINSERTPROCESSREFERENCESRELOADSELECTSHUTDOWNUPDATEUSAGE
  Q/ g* L3 V0 E- b3 D
7 S4 r: W/ N% N0 f- @* y
) ~' _% ~7 q( @( J9 s' n$ e

# j1 X/ k8 F. e
* o3 d% T& R7 g& b
鞈銵(Table)怎車甈:& S& M: n. m( Y- r" C% L# H
; q9 @% A& k1 |' L2 R# G
: X5 S1 [6 s9 ?1 B
SELECTINSERTUPDATEDELETECREATEDROPINDEXALTER) K  X, B. ]8 t: d: Y
/ i+ w3 ^3 x+ S# r$ l! K7 _6 _% t8 |

) E: ]. ]2 g3 K+ U( M$ d, O$ `# J8 k3 f7 {( A' q4 f

7 d+ u; P) ]  ?* e, A/ b鞈甈(column)銝蝔格:
% G" c: O  i# `! U0 d4 X5 p& @, O/ E+ Q& f" y8 {
0 K. K3 q" F  y7 r! ~- r. z
SELECT INSERT UPDATE
8 L5 h5 d3 w$ @+ u2 _2 N
- w  w% A' H( T5 n$ R5 }/ X* ^1 o5 g! v7 W* [
1 M9 {3 ~* v  q6 L' y8 t
撖虫:
8 D6 E" s5 G4 z7 T
1 R- _7 d" M( E. q
7 U5 p4 }% M0 j- W6 L
[root@localhost ~]# mysql -u root -p8 K( c( M4 _* p# h" a
Enter password:! W6 u! x/ g8 T0 M7 C$ \+ p
Welcome to the MySQL monitor.  Commands end with ; or \g.1 {" u" v+ U( l9 [) }' n* l1 U8 i: j
Your MySQL connection id is 2
. q, n& J% m* E! S: AServer version: 5.1.52 Source distribution# @: g% R. R5 ~" S7 x* I9 x
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.# H  h$ [" v# i& d
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
" c3 h$ [0 N. ~  t6 {and you are welcome to modify and redistribute it under the GPL v2 license1 V' `  g5 G/ k& [

8 ?4 [- s1 z# g" ^
# F) r6 p9 }- _( P& z
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
6 r- Q: k: V+ A4 p- T6 M/ K$ I" {8 n$ e. k1 ]# L

& v3 J6 O, L3 ^. mmysql> grant all privileges on *.* to test@localhost identified by '1234567'; //蝚砌留atabase嚗蝚砌眩able* R" w0 Z# [, e" K: A) j
2 R: g- k: m3 C, [
& K. ~2 b7 r4 C, A
Query OK, 0 rows affected (0.00 sec)     //撱箇test撣唾祆甈/ L, r( n* r$ C3 z$ O7 k7 v6 L

6 v( |3 }/ A/ \* M2 X
$ ~/ X* ~3 I2 }: N
mysql> grant all privileges on *.* to [email protected] identified by '1234567';  g$ p. b3 |/ y$ [, x  V

' ^# W  I1 W9 ^8 o3 x( W
6 d# D0 i1 X! m
Query OK, 0 rows affected (0.01 sec)   //撱箇test撣唾蝡舀" _  b4 `/ T: z) L

! b# ?7 w0 }: f2 x* W! a( ]
- ]; e0 i2 m, R. }6 o, L# l

6 A) N! m, V, d  g" T0 A% l+ [mysql> select host,user from mysql.user;   //亥岷MySQL甈撣唾8 a& }* e+ o% v+ l1 \" R9 Y: R
* K7 O% a/ b0 a  _4 R3 a$ j/ E

3 ^  |! |9 Z- L+ H1 N9 i' u+-----------------------+-------+2 {, O& f" @# L, P, k9 {$ F
| host                  | user  |
* y" D" t0 S( N! \6 J+-----------------------+-------+
; b. S. w& h, C! X| 127.0.0.1             | root  |
0 C7 ^; W/ x% I& l| 192.168.1.2           | test  |       //撣唾test蝡舀甈/ j- q* i2 R" ?* L- z' V' f
| localhost             |       |
, y! q- h2 ~' {| localhost             | test  |        //撣唾test祆甈4 p+ }6 y- ]5 M5 i: V7 P
| localhost             | root  |2 B% f, j9 i% B
| localhost.localdomain |       |
1 V, T' J9 x' a6 ~" M$ h. g| localhost.localdomain | root  |
/ V( c+ }! E, O+-----------------------+-------++ m2 F5 u0 l+ ^8 H2 H+ S1 Z  b9 e
7 rows in set (0.00 sec)6 n' s3 Z1 w1 `

) ?1 j) f7 A' ?; O1 x3 E

. U* W/ W1 k7 F7 G- @5 [mysql> quit   //aMySQL
4 Z8 M3 ~) T4 y5 Y7 UBye- ?9 j. k5 ?; @( N- v3 h
[root@localhost ~]
' I" Z# e, G' A2 ~/ M

2 Z8 p/ U  w9 Z$ N& m: v% cp.s 嗡mysql 閬隤瘜隢http://mail.hmes.kh.edu.tw/~jona/redhat/mysqlphp/mysqlsyntax.htm
+ U/ r  E7 ]6 _) E, H2 E: t

5 F( c# \1 U: ]( z; H: m5 O1 {5 l. b! u; ]  F. l  m2 O- Q

雿輻券

祉蝛閬

砍憛批捆靘餉衣雯頝臬批捆蝝颲行粹嗥蝬脩嚗摰撟湔遛嚗嚗甇脖誑銝嗅啣摰嗆摰撟湧翩鈭箏ㄚ孵舫脣伐銝憿亙祉璇甈橘芣遛18甇 雓蝯脣亦閬賬粹脩芣遛18甇脖芣撟渡雯閬賜雯頝臭嗥批捆鞈閮嚗撱箄降典舫脰蝬脰楝批捆蝝蝯蝜ICRA蝝摰鋆閮剖 (粹蝯行霅 祉蝬脣銝蝝瘛函隢憯啣嚗祉閮剜蝞∠)

QQ|撠暺撅||52AV璈A

GMT+8, 2026-3-19 21:48 , Processed in 0.083809 second(s), 16 queries .

蝯∠.撱

[email protected] | QQ:2405733034     since 2015-01

鋆貉憒 敹恍敺 餈銵