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.

  1. 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.