Advertisement
Guest User

Untitled

a guest
Nov 28th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. dbname="pbx_gui";
  2. dbuser='emadema';
  3. dbpass='emadema1';
  4.  
  5. fwdbname="freeswitch";
  6. fwdbuser='freeswitch';
  7. fwdbpass='freeswitch';
  8.  
  9. #IF NOT DEFINED SET MYSQL PASSWORD
  10. SQL=""
  11. SQL=${SQL}"CREATE DATABASE IF NOT EXISTS $dbname;"
  12. SQL=${SQL}"GRANT USAGE ON *.* TO '$dbuser'@'localhost' IDENTIFIED BY '$dbpass';"
  13. SQL=${SQL}"GRANT ALL PRIVILEGES ON $dbname.* TO '$dbuser'@'localhost';"
  14. SQL=${SQL}"FLUSH PRIVILEGES;"
  15.  
  16. SQL=${SQL}"CREATE DATABASE IF NOT EXISTS $fwdbname;"
  17. SQL=${SQL}"GRANT USAGE ON *.* TO '$fwdbuser'@'localhost' IDENTIFIED BY '$fwdbpass';"
  18. SQL=${SQL}"GRANT ALL PRIVILEGES ON $fwdbname.* TO '$fwdbuser'@'localhost';"
  19. SQL=${SQL}"FLUSH PRIVILEGES;"
  20.  
  21. SQL=${SQL}"USE $dbname;"
  22. SQL=${SQL}"source /var/www/pbx_gui/private/MYSQL/schema.sql;"
  23. SQL=${SQL}"source /var/www/pbx_gui/private/MYSQL/data.sql;"
  24.  
  25.  
  26. mysqladmin ping > /dev/null 2>&1 && up=1 || up=0
  27. if [ $up -eq 0 ] ; then
  28. service mysql start
  29. fi
  30.  
  31. ##Mysql default configuration
  32. echo 'Updating default schema...'
  33. #chmod 777 "$DEFAULT_SCHEMA_FILE"
  34. echo 'Running Mysql configuration...'
  35. dbpassroot='bitbush2016asdaasdfokeafad';
  36. mysql -uroot -p$dbpassroot -e "$SQL"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement