/*!40100 set old_passwords=1 */;/*!40100 set global old_passwords=1 */;--
-- localhost
--

-- wikiuser

GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'wikiuser'@'localhost' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `boardvote%`.* TO 'wikiuser'@'localhost' IDENTIFIED BY '';
GRANT SELECT, INSERT, UPDATE, DELETE ON `%wik%`.* TO 'wikiuser'@'localhost' IDENTIFIED BY '';

-- wikiadmin

GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'wikiadmin'@'localhost' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `boardvote%`.* TO wikiadmin@'localhost' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `%wik%`.* TO wikiadmin@'localhost' IDENTIFIED BY '';

--
-- 10.0.%
--

-- wikiuser

GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'wikiuser'@'10.0.%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `boardvote%`.* TO 'wikiuser'@'10.0.%' IDENTIFIED BY '';
GRANT SELECT, INSERT, UPDATE, DELETE ON `%wik%`.* TO 'wikiuser'@'10.0.%' IDENTIFIED BY '';

-- wikiadmin

GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'wikiadmin'@'10.0.%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `boardvote%`.* TO wikiadmin@'10.0.%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `%wik%`.* TO wikiadmin@'10.0.%' IDENTIFIED BY '';

--
-- 66.230.200.%
--

-- wikiuser

GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'wikiuser'@'66.230.200.%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `boardvote%`.* TO 'wikiuser'@'66.230.200.%' IDENTIFIED BY '';
GRANT SELECT, INSERT, UPDATE, DELETE ON `%wik%`.* TO 'wikiuser'@'66.230.200.%' IDENTIFIED BY '';

-- wikiadmin

GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'wikiadmin'@'66.230.200.%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `boardvote%`.* TO wikiadmin@'66.230.200.%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON `%wik%`.* TO wikiadmin@'66.230.200.%' IDENTIFIED BY '';