Advertisement
Guest User

Untitled

a guest
Oct 21st, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. $ cat newuser.sql|mysql --user=gaius --password=abc123 somedb
  2.  
  3. #!/bin/bash
  4.  
  5. echo "create user '$1'@'%' identified by password('$2');"|mysql --user=root --password=secret
  6. cat newuser.sql|mysql --user=$1 --password=$2 somedb
  7.  
  8. $ ./newuser.sh gaius abc123
  9.  
  10. create db.view as select ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement