雿輻 root 脣 MySQL+ R" G' @' o! ]# W
7 E) X- r; w7 G& J% H$ Z5 c4 o9 ]8 |9 j
; ~2 ]/ O0 N2 ^; l/ E; g+ g; W) |8 j4 c7 P
乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈' D0 o( o9 z# ]$ J
- use mysql;% d0 T1 c# x6 N8 g9 H0 F
- & ~5 L4 a. M5 p+ n; Y" o) s
- INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣
. d" }1 q/ {& y. j9 S4 ^( W憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
0 [$ G {* z* r- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 * }: [, H0 @0 {9 O: p, a2 {( ~
蝯虫雿輻刻孵鞈摨怎雿甈嚗- GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
* w/ y8 p) U; d* }: E
銴鋆賭誨蝣 $ b; m- |! s1 Z
蝯虫雿輻刻鞈摨怎雿甈嚗
( L ~! u! o1 U4 |0 r n W5 y! W- GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣 憪:
7 R1 c* F q6 P0 k/ V7 }3 K4 D+ p" _& r5 F2 q( [2 b
|
|