Contents

DROP DATABASE IF EXISTS test;

<% @variables.each do |mysql| -%>
<% if mysql[:action] == 'grant' -%>

CREATE DATABASE IF NOT EXISTS `<%= mysql[:database] %>`;
GRANT <%= mysql[:grants].join(', ') %>
      ON `<%= mysql[:database] %>`.*
      TO `<%= mysql[:user] %>`@`<%= mysql[:host] %>`
      IDENTIFIED BY '<%= DanarchyDeploy::Helpers.decode_base64(mysql[:password]) %>';

<% elsif mysql[:action] == 'revoke' -%>

REVOKE <%= mysql[:grants].join(', ') %>
      ON `<%= mysql[:database] %>`.*
      FROM `<%= mysql[:user] %>`@`<%= mysql[:host] %>`;

<% elsif mysql[:action] == 'drop' %>

DROP DATABASE IF EXISTS <%= mysql[:database] %>;
REVOKE ALL PRIVILEGES
      ON `<%= mysql[:database] %>`.*
      FROM `<%= mysql[:user] %>`@`<%= mysql[:host] %>`;
DROP USER `<%= mysql[:user] %>`;

<% elsif mysql[:action] == 'dropuser' %>

DROP USER IF EXISTS `<%= mysql[:user] %>`@`<%= mysql[:host] %>`;

<% end -%>
<% end -%>

FLUSH PRIVILEGES;

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
danarchy_deploy-0.2.11	templates/services/mysql/user_db_grants.sql.erb
danarchy_deploy-0.2.10	templates/services/mysql/user_db_grants.sql.erb
danarchy_deploy-0.2.9	templates/services/mysql/user_db_grants.sql.erb
danarchy_deploy-0.2.8	templates/services/mysql/user_db_grants.sql.erb