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...) |
(cat installation) |
||
| Line 20: | Line 20: | ||
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES ON `hgcentral`.* TO 'genome'@'localhost' | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES ON `hgcentral`.* TO 'genome'@'localhost' | ||
</pre> | </pre> | ||
[[category:installation]] | |||
Latest revision as of 15:24, 16 May 2012
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'
