雿輻 root 脣 MySQL( {; F, H' b0 M( A, d
2 E' Z: \0 X$ B( z5 q- L9 Q/ |) r; o; g/ l E2 w, ]
Q8 R" n+ w3 T. `; O
乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
. f' F: p I7 P* _2 B- use mysql;" R0 T) K; e( u5 v# y
- 6 C# H& f, ^2 F# M& I" @3 _% w
- INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 6 N- p6 f+ t. j9 m* R+ g/ Z
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
( ^+ S" S/ K$ E( ?* e9 b- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣
$ N( U5 n% S. J蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';! v8 U1 n7 D j
銴鋆賭誨蝣 6 b1 P" Y8 J1 [! N/ K( ]4 K$ S7 t
蝯虫雿輻刻鞈摨怎雿甈嚗
4 \/ p+ A* Q: _- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:* T4 E" j$ p) ]0 X
3 U2 v8 D+ e. a. @ |
|