Specify the version#
The default version is 8.0.
To override the version, update the server’s Pillar file:
mysql: version: '8.0'
Add users, groups and databases#
To configure the database for an application:
Add a user for the application, in a private Pillar file, replacing
PASSWORDwith a strong password (uncheck Symbols) and
USERNAMEwith a recognizable username:
mysql: users: USERNAME: password: "PASSWORD"
Create the database for the application and grant all privileges to the new user. Replace
mysql: users: USERNAME: password: "PASSWORD" databases: DATABASE: user: USERNAME
Add the private Pillar file to the top file entry for the application.
Even if you don’t need to configure MySQL, you must still set the following, in order for its SLS file to be automatically included:
mysql: configuration: False
Put your configuration file in the salt/mysql/files/conf directory.
mysql.configurationin the server’s Pillar file:
mysql: configuration: redmine
The configuration file will be in the
/etc/mysql/conf.d directory on the server.