雿輻 root 脣 MySQL
5 P x' x& `3 f1 g. n2 N8 x1 p( L/ [$ L/ A! R) Y4 T* K( y
+ d# W0 h: T; N1 s3 `; ]
6 ~7 H# b4 b, @, @0 j. T乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
6 B; n5 R8 D+ \- use mysql;
$ q. b7 T: o1 h, `8 g" e -
5 y6 f- e5 p8 w$ R+ Z' R - INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 2 b) y3 M' o7 f6 Y
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗4 o1 ?1 v6 e3 d5 y& f( _0 k
- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣
" Q4 R& ]& I- J4 g4 ]- l- m* U3 t蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';+ I& O+ f* B. |$ ]
銴鋆賭誨蝣
; L8 Z, I+ f' v蝯虫雿輻刻鞈摨怎雿甈嚗, f+ O5 P$ ]0 z5 M6 V% d
- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:1 s9 g5 q7 @, F- Q
, M( I" E; l1 x# [4 | |
|