Advertisement
Guest User

Untitled

a guest
Mar 15th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. mysql -e "create database if not exists ${UN}_${SQLBASE}"
  2. mysql -Be "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE ROUTINE ON `"$UN"\_"$SQLBASE"`.* TO '"$UN"_"$SQLUSER"'@'localhost' IDENTIFIED BY '$SQLPASS';FLUSH PRIVILEGES"
  3.  
  4. username="usernamedb"
  5. password="passworddb"
  6.  
  7. database="cpanel_db"
  8. databases=$(mysql -u $username -p$password -Bse 'show databases'|grep $database)
  9.  
  10. max=1
  11.  
  12. if [ -z "$databases" ];then
  13. mysql -u $username -p$password -Bse "create database ${database}$max"
  14. else
  15. for cdatabase in $databases
  16. do
  17. cdatabasenumber=$(echo $cdatabase|awk -F"db" '{print $2}')
  18. if [ $cdatabasenumber -gt $max ]; then
  19. max=$cdatabasenumber
  20. fi
  21. done
  22. let max++
  23.  
  24. mysql -u $username -p$password -Bse "create database ${database}$max"
  25. fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement