/*!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 '';