Skip to content

Instantly share code, notes, and snippets.

@dincosman
Created June 2, 2024 19:08
Show Gist options
  • Select an option

  • Save dincosman/18d2590130caaa95d588137202c85a43 to your computer and use it in GitHub Desktop.

Select an option

Save dincosman/18d2590130caaa95d588137202c85a43 to your computer and use it in GitHub Desktop.
MaxScale Configuring database user with specific privileges
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