Created
March 2, 2023 09:15
-
-
Save CbcWestwolf/c8c92277d3f8ab26951c848607290e75 to your computer and use it in GitHub Desktop.
init.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE USER cloud_admin; | |
GRANT BACKUP_ADMIN, RESTORE_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT DASHBOARD_CLIENT on *.* TO 'cloud_admin'@'%'; | |
GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT CONNECTION_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT RESTRICTED_VARIABLES_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT RESTRICTED_STATUS_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT RESTRICTED_CONNECTION_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT RESTRICTED_USER_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT RESTRICTED_TABLES_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT RESTRICTED_REPLICA_WRITER_ADMIN ON *.* TO 'cloud_admin'@'%'; | |
GRANT CREATE USER ON *.* TO 'cloud_admin'@'%'; | |
GRANT RELOAD ON *.* TO 'cloud_admin'@'%'; | |
GRANT PROCESS ON *.* TO 'cloud_admin'@'%'; | |
GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.* TO 'cloud_admin'@'%'; | |
GRANT SELECT ON information_schema.* TO 'cloud_admin'@'%'; | |
GRANT SELECT ON performance_schema.* TO 'cloud_admin'@'%'; | |
GRANT SHOW DATABASES on *.* TO 'cloud_admin'@'%'; | |
GRANT REFERENCES ON *.* TO 'cloud_admin'@'%'; | |
GRANT SELECT ON *.* TO 'cloud_admin'@'%'; | |
GRANT INDEX ON *.* TO 'cloud_admin'@'%'; | |
GRANT INSERT ON *.* TO 'cloud_admin'@'%'; | |
GRANT UPDATE ON *.* TO 'cloud_admin'@'%'; | |
GRANT DELETE ON *.* TO 'cloud_admin'@'%'; | |
GRANT CREATE ON *.* TO 'cloud_admin'@'%'; | |
GRANT DROP ON *.* TO 'cloud_admin'@'%'; | |
GRANT ALTER ON *.* TO 'cloud_admin'@'%'; | |
GRANT CREATE VIEW ON *.* TO 'cloud_admin'@'%'; | |
GRANT SHUTDOWN, CONFIG ON *.* TO 'cloud_admin'@'%'; | |
REVOKE SHUTDOWN, CONFIG ON *.* FROM root; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment