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.
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: '%' - connection_charset: utf8 - saltenv: - LC_ALL: "en_US.utf8" - require: - mysql_database: stg_databases
Create and edit
/opt/salt-cookbook/staging/mysql/grants.sls...