O'Reilly logo

Salt Cookbook by Anirban Saha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required