雿輻 root 脣 MySQL N; ?% f+ R9 N( c+ C" }
& P$ w5 H) g2 u: W
& r( I9 G/ B; l" l3 H/ S. p
0 K4 `7 I9 b! j" F/ Z, I+ ]乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
7 p2 I! X; q8 j; I% O& O2 O. a- use mysql;
! r/ h3 A/ @- M& ?% J1 t- H -
! O- Q5 W. A& M# ]1 s% L( a2 ]7 X - INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 ; L/ K5 ~" o1 |
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
8 M6 x, Y" D' p+ x9 R) {- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣
5 U& E8 s; f1 M5 T蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
# U' i6 N L) h0 j+ ~- g
銴鋆賭誨蝣 + D' Z+ h. ~ h0 o$ _0 ^3 ?; a
蝯虫雿輻刻鞈摨怎雿甈嚗4 H& m$ D) p% L
- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:" A, d) h! Y/ A, M0 h5 u
3 I- d) }0 l" B% s5 i4 w |
|