/*-----------------
db1
-----------------*/
GRANT ALL PRIVILEGES ON *.* TO 'repl'@'192.245.255.11' IDENTIFIED BY 'Hzpd5N*7p' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'repl'@'108.170.32.34' IDENTIFIED BY 'Hzpd5N*7p' WITH GRANT OPTION;

/*-----------------
gateway - app
-----------------*/
GRANT ALL PRIVILEGES ON  sellerso_helpspot.* TO sellerso_help@`192.245.255.8` identified by '437p$p07' WITH GRANT OPTION;

grant all on sellerso_affiliates.* to sellerso_affadmi@`192.245.255.%` identified by 'eeKA800^^';
grant all on sellerso_cnl2.* to sellerso_cnl2@`192.245.255.%` identified by 'f7412dvm';
grant all on sellerso_arp3.* to sellerso_arpadmi@`192.245.255.%` identified by 'eeKA800^^';

GRANT ALL PRIVILEGES ON sellerso_sellersonuke.* TO sellerso_amember@`192.245.255.%` identified by password '4e64ff11162d6eb1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON sellerso_amember.* TO sellerso_amember@`192.245.255.%` ;
GRANT ALL PRIVILEGES ON ssbdata.serverfarm TO sellerso_amember@`192.245.255.%` ;

GRANT ALL PRIVILEGES ON *.* TO appuser@`192.245.255.%` identified by '#appus3r#' WITH GRANT OPTION;
GRANT CREATE TEMPORARY TABLES ON *.* TO appuser@`192.245.255.%` ;
GRANT ALL PRIVILEGES ON *.* TO appuser@`108.170.30.202` identified by '#appus3r#' WITH GRANT OPTION;
GRANT CREATE TEMPORARY TABLES ON *.* TO appuser@`108.170.30.202`;















/*-----------------
mysql -h108.170.32.34 -uappuser-p#appus3r#


+  OLD
| GRANT CREATE USER ON *.* TO 'sellerso_dammit'@'207.210.119.%' IDENTIFIED BY PASSWORD '*16631200DBFCA1CC324F60AE3003C8EB59F608F5'                                                                                                               |
| GRANT ALL PRIVILEGES ON `ssbdata`.* TO 'sellerso_dammit'@'207.210.119.%' WITH GRANT OPTION                                                                                                                                                     |
| GRANT ALL PRIVILEGES ON `ssb`.* TO 'sellerso_dammit'@'207.210.119.%' WITH GRANT OPTION                                                                                                                                                         |
| GRANT ALL PRIVILEGES ON `ssbbackup`.* TO 'sellerso_dammit'@'207.210.119.%' WITH GRANT OPTION                                                                                                                                                   |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `sellerso_sellersonuke`.* TO 'sellerso_dammit'@'207.210.119.%' WITH GRANT OPTION |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `sellerso_amember`.* TO 'sellerso_dammit'@'207.210.119.%' WITH GRANT OPTION      |
| GRANT ALL PRIVILEGES ON `sellerso_affiliates`.* TO 'sellerso_dammit'@'207.210.119.%' WITH GRANT OPTION                                                                                                                                         |
| GRANT ALL PRIVILEGES ON `archive_data`.* TO 'sellerso_dammit'@'207.210.119.%' WITH GRANT OPTION                                                                                                                                                |
+----------------------------------------------------------------------------------------------------------------------------------


-----------------*/


/*-----------------
LEGACY
GRANT ALL PRIVILEGES ON *.* TO 'ssbebay_appserve'@`108.170.30.202` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'sellerso_dammit'@'207.210.119.%' identified by 'f7412dvm' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON  sellerso_helpspot.* TO sellerso_help@`207.210.119.%` identified by '437p$p07' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssb.* TO 'ssbebay_appserve'@`192.245.255.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'ssbebay_appserve'@`192.245.255.%` identified by  'S$b3B@y' WITH GRANT OPTION;


GRANT ALL PRIVILEGES ON sellerso_sellersonuke.* TO 'ssbebay_appserve'@`207.210.119.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssb.* TO 'ssbebay_appserve'@`207.210.119.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssbdata.* TO 'ssbebay_appserve'@`207.210.119.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON sellerso_sellersonuke.* TO 'ssbebay_appserve'@`108.170.%.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssb.* TO 'ssbebay_appserve'@`108.170.%.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssbdata.* TO 'ssbebay_appserve'@`108.170.%.%` identified by  'S$b3B@y' WITH GRANT OPTION;


GRANT ALL PRIVILEGES ON ssbebay_alprod.* TO 'ssbebay_appserve'@`207.210.119.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssbebay_aldev.* TO 'ssbebay_appserve'@`207.210.119.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssbebay_alprod.* TO 'ssbebay_appserve'@`108.170.%.%` identified by  'S$b3B@y' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON ssbebay_aldev.* TO 'ssbebay_appserve'@`108.170.%.%` identified by  'S$b3B@y' WITH GRANT OPTION;

-----------------*/



FLUSH PRIVILEGES;

