雿輻 root 脣 MySQL
2 p0 Q' R! v {" B3 M
, [2 D! T1 K h! W2 p- C/ f. V- C Y% b1 K, p) p3 V6 m9 U: @* L
7 K, w% Y) a% U8 h( p: k. v乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
: [; m+ H# o, x: X, }0 P, M$ u! b- use mysql;- L/ q; }1 |0 U! A) v$ ?# U
- 8 g3 u* Q( a' \* a
- INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 6 \8 G5 V; q2 i, G: U! k
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
( G" v; ^0 @7 J- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 3 Q2 H. b n5 |* ]. t7 ~4 o
蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
i9 H, m4 u! z' ^: A2 T
銴鋆賭誨蝣 + {5 f4 t, Q4 \) [6 J
蝯虫雿輻刻鞈摨怎雿甈嚗" `% d5 \" H: M; x8 N# F
- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:
5 G' q4 x8 p% D
. [5 W6 I5 ~$ a3 \# }3 X# ~ |
|