Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dbname="pbx_gui";
- dbuser='emadema';
- dbpass='emadema1';
- fwdbname="freeswitch";
- fwdbuser='freeswitch';
- fwdbpass='freeswitch';
- #IF NOT DEFINED SET MYSQL PASSWORD
- SQL=""
- SQL=${SQL}"CREATE DATABASE IF NOT EXISTS $dbname;"
- SQL=${SQL}"GRANT USAGE ON *.* TO '$dbuser'@'localhost' IDENTIFIED BY '$dbpass';"
- SQL=${SQL}"GRANT ALL PRIVILEGES ON $dbname.* TO '$dbuser'@'localhost';"
- SQL=${SQL}"FLUSH PRIVILEGES;"
- SQL=${SQL}"CREATE DATABASE IF NOT EXISTS $fwdbname;"
- SQL=${SQL}"GRANT USAGE ON *.* TO '$fwdbuser'@'localhost' IDENTIFIED BY '$fwdbpass';"
- SQL=${SQL}"GRANT ALL PRIVILEGES ON $fwdbname.* TO '$fwdbuser'@'localhost';"
- SQL=${SQL}"FLUSH PRIVILEGES;"
- SQL=${SQL}"USE $dbname;"
- SQL=${SQL}"source /var/www/pbx_gui/private/MYSQL/schema.sql;"
- SQL=${SQL}"source /var/www/pbx_gui/private/MYSQL/data.sql;"
- mysqladmin ping > /dev/null 2>&1 && up=1 || up=0
- if [ $up -eq 0 ] ; then
- service mysql start
- fi
- ##Mysql default configuration
- echo 'Updating default schema...'
- #chmod 777 "$DEFAULT_SCHEMA_FILE"
- echo 'Running Mysql configuration...'
- dbpassroot='bitbush2016asdaasdfokeafad';
- mysql -uroot -p$dbpassroot -e "$SQL"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement