Advertisement
Guest User

Untitled

a guest
Nov 28th, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 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}"USE $dbname;"
  19. SQL=${SQL}"source /var/www/pbx_gui/private/MYSQL/schema.sql;"
  20. SQL=${SQL}"source /var/www/pbx_gui/private/MYSQL/data.sql;"
  21.  
  22.  
  23. mysqladmin ping > /dev/null 2>&1 && up=1 || up=0
  24. if [ $up -eq 0 ] ; then
  25. service mysql start
  26. fi
  27.  
  28. ##Mysql default configuration
  29. echo 'Updating default schema...'
  30. #chmod 777 "$DEFAULT_SCHEMA_FILE"
  31. echo 'Running Mysql configuration...'
  32. dbpassroot='bitbush2016asdaasdfokeafad';
  33. mysql -uroot -p$dbpassroot -e "$SQL"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement