Example Mysql Grants

These are the commmands that we have to execute on our UCSC mirror to get all rights for the user genome/password genome for the assemblies we're mirroring:

GRANT USAGE ON *.* TO 'genome'@'localhost' IDENTIFIED BY PASSWORD '4f9961e16b4050d4'
GRANT SELECT, CREATE TEMPORARY TABLES ON `proteome`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `genbank`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `mm9`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `dm39`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `dm3`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `hg18`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `proteins040315`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `ci2`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `ci1`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `uniProt`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `proteins060115`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `hg19`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `mm8`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `oryLat2`.* TO 'genome'@'localhost'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `customTrash`.* TO 'genome'@'localhost'
GRANT SELECT, CREATE TEMPORARY TABLES ON `hgFixed`.* TO 'genome'@'localhost'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES ON `hgcentral`.* TO 'genome'@'localhost'