雿輻 root 脣 MySQL) G6 f+ }5 ?9 `7 J, S2 y" V
4 i& ^# X e' |! O( ~; ]
5 _1 }: b8 I: J( ~( a F) ^" s
) S& }$ p6 _2 a* B# M( J
乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈4 l: a/ d; i6 H+ G
- use mysql;
# a# t7 u! w) X" U5 p5 A- _ -
/ e5 O* F1 z1 A# q+ G - INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 2 R- M' G: ?+ v0 S6 ?; y6 ]! P
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
& q9 ?6 R2 L7 a$ @/ |- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 * l) D D$ n+ T. M! J9 I
蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';2 y' ?4 A N0 G8 g! ^
銴鋆賭誨蝣 2 G- Q2 a# q0 R' O8 @* S' @
蝯虫雿輻刻鞈摨怎雿甈嚗9 V3 u! M+ ]3 j# k ]0 s% a( a
- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:
5 {5 {! f9 G0 ?7 q5 I; \, m* G- j# v1 G! K
|
|