雿輻 root 脣 MySQL O/ f) \9 X/ q8 m. _2 F; t
/ I' b& F2 B5 E( c
7 I4 F. p6 r5 Q2 P; K* `- n. s3 E9 x+ U8 O: Q; g8 }* Q/ @* e
乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
- C1 b; e4 H4 q- use mysql;
* ?0 f6 @8 Y1 \: D0 m# Z9 x% E - - [% v) d" Y; p) {7 B- P
- INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 : @2 [9 L2 Q8 ~
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗) e7 ~3 j' }+ _ z% h
- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 9 T, J9 [( U# H( T; @
蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';" ^3 R& I: @, v' M
銴鋆賭誨蝣 . b( Z" z) y b9 ? l( {0 M1 T
蝯虫雿輻刻鞈摨怎雿甈嚗! z0 ]% R$ I0 P( ^& f+ h2 M- f& t3 L
- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:
' z; @% ` ]. q$ C6 V
+ ?$ Q- Q' l% ] |
|