mysql
mysql copied to clipboard
One example for multiple grants ?
Here the command line I'm willing to do with ansible
mysql -u root -p -e "grant all on centreon.* to 'centreon'@localhost identified by 'centreon'; grant all on centreon_storage.* to 'centreon'@localhost identified by 'centreon'; grant all on centreon_status.* to 'centreon'@localhost identified by 'centreon';"
I've a meta/main.yml like this
---
dependencies:
- { role: httpd }
- { role: mysql, mysql_root_db_pass: centreon, mysql_users: [{name: centreon, pass: centreon, priv: "centreon.*:ALL"}] }
# Need centreon_storage et centreon_status
How would you do that? That could make one more example (or a tweak in a existing one) in the README.md