雿輻 root 脣 MySQL
" w6 e. j% R1 W) e8 k* o9 d$ |
6 H% ]3 J1 u+ J4 b
; f- Z( k; b: V! O; x3 f9 ~
* M, n) g0 m' O' Q乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
! I$ G% K f0 H2 ~! t, M! }$ _/ S- use mysql;" s5 y! q5 a! }; C0 x% ~. ^
-
# T# t6 _% k8 G5 { - INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣
. J/ u9 G" a: j# {9 F- c3 Y) F憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
7 Z: E3 e6 @3 o" Z) m: N1 Z- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 % b3 h s. Q) `1 T8 H
蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';4 ~9 o$ j0 X# m
銴鋆賭誨蝣 0 F4 L3 k" L ~( H
蝯虫雿輻刻鞈摨怎雿甈嚗
' Q8 N9 ?+ X, s# N" \! E8 p$ ]: [7 w/ `- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:; O% l- i9 t" j
3 P. Z; P( Q; C# f/ i
|
|