52AV璈A|52AV.ONE

 曉撖蝣
 蝡唾酉
敹急瑕
  • av隢憯BBS
  • 璈A
  • 芣瑟憭瘚
  • 鞎澆
  • 52av鋆貉摰
  • 銝剜-銝剖銝餅
     
亦: 3823|敺: 0
銝銝銝駁 銝銝銝駁

[mysql] MySql 啣雿輻刻閮剖甈

[銴鋆賡包
頝唾唳摰璅撅
璅銝
潸” 2015-6-23 08:29:20 | 芰閰脖 撣 |摨閬 |梯璅∪
雿輻 root 脣 MySQL
: d4 m8 \  J3 N8 U4 G/ K) h+ }: Q5 ?& i
  1. mysql -u root -p
銴鋆賭誨蝣

! }, x- X+ `5 p# \
' |' r  {+ O/ O. _乩靘啣銝雿輻刻 user1, 撖蝣潸身摰 user1pwd, 銝虫蝯虫鞈摨怎甈
. w# v: A0 v1 c
  1. use mysql;( c4 i5 Q7 K, _) Y% }7 v+ |

  2. + ?2 c5 }/ C# p. Q3 b
  3. INSERT INTO user(host,user,password) VALUES('%','user1',password('user1pwd'));
銴鋆賭誨蝣

" u0 f* \& ?9 [9 `- S2 l, M憒閬蝯虫雿輻刻孵鞈摨怎鈭雿甈嚗
9 L+ G4 d- s/ o! ], i& d4 X
  1. GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣
0 H, y- H3 V$ M' m4 R% Y
蝯虫雿輻刻孵鞈摨怎雿甈嚗
  1. GRANT all ON dbname.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';. r* X6 T/ ~! g" C; |
銴鋆賭誨蝣

2 |! J5 Z/ w9 Q% S0 p6 Y! d- c蝯虫雿輻刻鞈摨怎雿甈嚗+ b) N7 Q% @+ j' e
  1. GRANT all ON *.* TO 'user1'@localhost IDENTIFIED BY 'user1pwd';
銴鋆賭誨蝣
憪:
  1. FLUSH PRIVILEGES;
銴鋆賭誨蝣

- n! A# V3 T3 H" }; j
8 B$ N& T$ R$ d# ^

雿輻券

祉蝛閬

砍憛批捆靘餉衣雯頝臬批捆蝝颲行粹嗥蝬脩嚗摰撟湔遛嚗嚗甇脖誑銝嗅啣摰嗆摰撟湧翩鈭箏ㄚ孵舫脣伐銝憿亙祉璇甈橘芣遛18甇 雓蝯脣亦閬賬粹脩芣遛18甇脖芣撟渡雯閬賜雯頝臭嗥批捆鞈閮嚗撱箄降典舫脰蝬脰楝批捆蝝蝯蝜ICRA蝝摰鋆閮剖 (粹蝯行霅 祉蝬脣銝蝝瘛函隢憯啣嚗祉閮剜蝞∠)

QQ|撠暺撅||52AV璈A

GMT+8, 2026-2-9 22:17 , Processed in 0.070250 second(s), 16 queries .

蝯∠.撱

52avtv@gmail.com | QQ:2405733034     since 2015-01

鋆貉憒 敹恍敺 餈銵