Created
June 2, 2024 19:08
-
-
Save dincosman/18d2590130caaa95d588137202c85a43 to your computer and use it in GitHub Desktop.
MaxScale Configuring database user with specific privileges
This file contains hidden or 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
| MariaDB [(none)]> CREATE USER 'maxscale'@'%' IDENTIFIED BY 'maxscale_pw'; | |
| MariaDB [(none)]> GRANT SELECT ON mysql.user TO 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SELECT ON mysql.db TO 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SELECT ON mysql.tables_priv TO 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SELECT ON mysql.columns_priv TO 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SELECT ON mysql.procs_priv TO 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SELECT ON mysql.proxies_priv TO 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SELECT ON mysql.roles_mapping TO 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SLAVE MONITOR on *.* to 'maxscale'@'%'; | |
| MariaDB [(none)]> GRANT SHOW DATABASES ON *.* TO 'maxscale'@'%'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment