雿輻 root 脣 MySQL
7 \. [- t7 E9 h' n; p/ Z
& U& C- H( P: e9 K7 a$ `
- ?1 M: ~* P3 J" t& c4 U+ }$ N# a3 }& Y2 d7 ~; d
乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
: q L0 C$ Y7 R3 ]+ g y1 U# `; s6 w- use mysql;) v3 ~. r3 |% H& u; f. u1 y1 N
- 8 I0 f3 w* f$ P& p/ U# N$ `7 ?
- INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣 , b4 e0 F: Q7 ?% S: ]) k% d( V
憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
+ u3 |, W5 Z7 T# I+ a1 @- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣
1 f' p+ P# E' a( y蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
$ p0 _0 k. F$ m
銴鋆賭誨蝣
" x8 p( E' y/ V3 y2 D, v/ _蝯虫雿輻刻鞈摨怎雿甈嚗& e4 l% ?. {7 f" K, I6 I7 }1 \' R% L
- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:6 W0 E6 A1 X) U0 e1 Q
- ~3 Y" |* O; R! Y( U1 M/ l6 A |
|