mysql
Install the MySQL client and/or server.
Note
See the full Salt Formulas installation and usage instructions.
Available states
mysql
Meta-state that includes all server packages in the correct order.
This meta-state does not include mysql.remove_test_database; see
below for details.
mysql.client
Install the MySQL client package.
mysql.server
Install the MySQL server package and start the service.
Debian OS family supports setting MySQL root password during install via debconf.
Note
If no root password is provided in the pillar, a random one will
be created. Because Hydrogen doesn't have easy access to a random
function (test.rand_str isn't introduced until Helium), instead,
we use the not-at-all random grains.server_id. As this is
cryptographically insecure, future formula versions should use the
newly available random.get_str method.
mysql.disabled
Ensure that the MySQL service is not running.
mysql.database
Create and manage MySQL databases.
mysql.python
Install mysql python bindings.
mysql.user
Create and manage MySQL database users with definable GRANT privileges.
The state accepts MySQL hashed passwords or clear text. Hashed password have priority.
Note
See the salt.states.mysql_user docs for additional information on configuring hashed passwords.
Make sure to quote the passwords in the pillar so YAML doesn't throw an exception.
mysql.remove_test_database
Warning
Do not use this state if your MySQL instance has a database in use called test.
If you do, it will be irrevocably removed!
Remove the database called test, normally created as part of a default
MySQL installation. This state is not included as part of the meta-state
above as this name may conflict with a real database.
mysql.dev
Install the MySQL development libraries and header files.
Note
Note that this state is not installed by the mysql meta-state unless you set your pillar data accordingly.
mysql.repo
Add the official MySQL 5.7 repository.
Note
Note that this state currently only supports MySQL 5.7 for RHEL systems. Debian and Suse support to be added. Also need to add the option to allow selection of MySQL version (5.6 and 5.5 repos are added but disabled) and changed enabled repository accordingly.