Example Mysql Grants: Difference between revisions
From genomewiki
Jump to navigationJump to search
(New page: 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: <pre> GRANT USAGE ON *.* TO 'ge...) |
(No difference)
|
Revision as of 18:22, 4 March 2010
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'