/*!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 '';
GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* 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 '';
GRANT ALL PRIVILEGES ON `centralauth`.* TO wikiadmin@'localhost' IDENTIFIED BY '';

-- nagios

GRANT REPLICATION CLIENT ON *.* TO 'nagios'@'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 '';
GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* 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 '';
GRANT ALL PRIVILEGES ON `centralauth`.* TO wikiadmin@'10.0.%' IDENTIFIED BY '';

-- nagios

GRANT REPLICATION CLIENT ON *.* TO 'nagios'@'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 '';
GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* 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 '';
GRANT ALL PRIVILEGES ON `centralauth`.* TO wikiadmin@'66.230.200.%' IDENTIFIED BY '';

-- nagios

GRANT REPLICATION CLIENT ON *.* TO 'nagios'@'66.230.200.%' IDENTIFIED BY '';

--
-- 208.80.152.%
--

-- wikiuser

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

-- wikiadmin

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

-- nagios

GRANT REPLICATION CLIENT ON *.* TO 'nagios'@'208.80.152.%' IDENTIFIED BY '';