mysql2_chef_gem 'default' do
          action :install
          end

          bash "Install mysql package" do
          user "root"
          code <<-EOF
          yum install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
          yum-config-manager --disable mysql56-community
          yum-config-manager --enable mysql55-community
          yum -y install mysql mysql-devel mysql-server mysql-utilities
          EOF
          end

          service "mysqld" do
          supports status: true, restart: true, reload: true
          action   [ :enable, :start ]
          end

          script "Secure install" do
          interpreter 'bash'
          user "root"
          only_if "mysql -u root -e 'show databases'"
          code <<-EOL
            mysqladmin -u root password "#{node['mysql']['root_password']}"
            mysql -u root -p#{node['mysql']['root_password']} -e "DELETE FROM mysql.user WHERE User='';"
            mysql -u root -p#{node['mysql']['root_password']} -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1');"
            mysql -u root -p#{node['mysql']['root_password']} -e "DROP DATABASE test;"
            mysql -u root -p#{node['mysql']['root_password']} -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%';"
            mysql -u root -p#{node['mysql']['root_password']} -e "FLUSH PRIVILEGES;"
          EOL
          end

          mysql_connection_info = {
          :host => node['mysql']['host'],
          :username => node['mysql']['root_username'],
          :password => node['mysql']['root_password'],
          }

          ["%", "localhost"].each do |hostname|
          mysql_database_user node['mysql']['app_username'] do
            connection mysql_connection_info
            password   node['mysql']['app_password']
            host       hostname
            privileges [:select, :insert, :update, :delete, :create, :drop, :reload,
                        :process,:references, :index, :alter,
                        "show databases", "create temporary tables", "lock tables"]
            action     [:create, :grant]
          end
          end

Compiled Resource:
  ------------------
  # Declared in /home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql2_chef_gem/libraries/provider_mysql2_chef_gem_mysql.rb:16:in `block in <class:Mysql>'

  mysql_client("default") do
    action [:create]
    retries 0
    retry_delay 2
    default_guard_interpreter :default
    declared_type :mysql_client
    cookbook_name "mysql_setup"
  end

  Platform:
  ---------
  x86_64-linux


================================================================================
Error executing action `install` on resource 'mysql2_chef_gem[default]'
================================================================================

NoMethodError
-------------
mysql_client[default] (/home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql2_chef_gem/libraries/provider_mysql2_chef_gem_mysql.rb line 16) had an error: NoMethodError: undefined method `[]' for nil:NilClass

Cookbook Trace:
---------------
/home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql/libraries/helpers.rb:390:in `package_name_for'
/home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql/libraries/helpers.rb:421:in `client_package'
/home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql/libraries/helpers.rb:29:in `client_package_name'
/home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql/libraries/provider_mysql_client.rb:20:in `block in <class:MysqlClient>'

Resource Declaration:
---------------------
# In /home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql_setup/recipes/default.rb

 10: mysql2_chef_gem 'default' do
 11:   action :install
 12: end
 13:

Compiled Resource:
------------------
# Declared in /home/ec2-user/chef-solo/local-mode-cache/cache/cookbooks/mysql_setup/recipes/default.rb:10:in `from_file'

mysql2_chef_gem("default") do
  action [:install]
  retries 0
  retry_delay 2
  default_guard_interpreter :default
  declared_type :mysql2_chef_gem
  cookbook_name "mysql_setup"
  recipe_name "default"
  gem_version "0.3.17"
end

Platform:
---------
x86_64-linux