#!/bin/bash
#####################################

# $user = 'demo1user';
# $password = 'Qwertie1';
# $db = 'demo1';
# $dbprefix = 'wbx63_';


# $user = 'demo2user';
# $password = 'Qwertie2';
# $db = 'demo2';
# $dbprefix = 'i1as5_';


#CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

#GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';


#mysql -u root -p

#GRANT ALL PRIVILEGES ON demo1.* To 'demo2user'@'localhost' IDENTIFIED BY 'Qwertie2';

#GRANT ALL PRIVILEGES ON demo2.* To 'demo4user'@'localhost' IDENTIFIED BY 'Qwertie4';

#GRANT ALL PRIVILEGES ON demo7.* To 'demo7user'@'localhost' IDENTIFIED BY 'Qwertie7';

# REVOKE ALL PRIVILEGES ON demo4.* From 'demo7user'@'localhost'

#GRANT ALL PRIVILEGES ON joomla351.* To 'joomla351user'@'localhost' IDENTIFIED BY 'QwertieJ351';

#mysqldump -u root -p --lock-all-tables --databases demo2 > /demo2_db.sql

#**************************************

#mysql -u demo1user -pQwertie1 < /demo1_db.sql

mysql -u demo2user -pQwertie2 < /demo2_db.sql

mysql -u demo7user -pQwertie7 < /demo7_db.sql

mysql -u demo4user -pQwertie4 < /demo4_db.sql
