雿輻 root 脣 MySQL' h& P( w1 h+ f' I$ K- W q
' l& u: {# o& ^
6 p4 G2 f+ J) d$ _9 R* N
K4 \7 E0 j7 \$ [" h乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
. G, \8 H+ A: t- use mysql;
0 o# q5 }7 e! p! B - ) [8 C$ }0 U& @( n
- INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 ! S: u% Z! C! x; y/ ?- Z
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗" i/ r( Y( i& o5 [) l0 S& d0 h$ Q" \
- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣
: Z- F. P8 d, N蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';. g# H# }4 m2 i- P
銴鋆賭誨蝣 0 V' X7 B) y; E" D( C
蝯虫雿輻刻鞈摨怎雿甈嚗3 p6 k( F% x+ B1 p+ w, n
- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:
5 t% X6 c: @1 M7 l( B* U- i/ J: J- Z9 _. j' Y; q4 d
|
|