Changes between Version 3 and Version 4 of jazz/13-12-21

Timestamp:

Dec 21, 2013, 2:33:09 PM (11 years ago)

Author:

jazz

Comment:

--

jazz/13-12-21

@@ -3 +3 @@
 == Sqoop ==
 
+ *
+{{{
+for ((i=1;i<=30;i++)); do printf "CREATE DATABASE user%02d;\n" $i; done > add_user_db.sql
+mysql -h 主機名稱 -u root -p < add_user_db.sql
+for ((i=1;i<=30;i++)); do printf "GRANT SELECT,INSERT,UPDATE ON user%02d.* TO 'user%02d'@'%s' IDENTIFIED BY '密碼';\n" $i $i '%'; done > add_user.sql
+echo "FLUSH PRIVILEGES;" >> add_user.sql
+mysql -h 主機名稱 -u root -p < add_user.sql
+}}}
  * 建立 MySQL 測試資料庫
 {{{