Providing MySQL user grants
In this recipe, you will learn about how to provide grants to MySQL users, that is, the permissions that a user has to perform operations on the databases, and how to relate them with other MySQL definitions.
How to do it...
We will use the same minion as the previous recipe.
- Modify
/opt/salt-cookbook/staging/mysql/users.sls
to have the following entries:include: - mysql.database first_db_user: mysql_user.present: - name: stg-admin - password_hash: '{{ pillar['mysql']['stg-passwd-hash'] }}' - host: '%' - connection_charset: utf8 - saltenv: - LC_ALL: "en_US.utf8" - require: - mysql_database: stg_databases second_db_user: mysql_user.present: - name: stg-db - password_hash: '{{ pillar['mysql']['stg-passwd-hash'] }}' - host: ...
Get Salt Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.