mysql_basic.md

#
# install daemon preconditions
#

include_recipe "apt"

mysql_root_password = "change me"
mysql_port = "3306"
wordpress_db = "wordpressdb"
wordpress_password = "change me2"
wordpress_user = "wordpressuser"
wordpress_dir = "/var/www/wordpress"
wordpress_auth_key = "change me3"
wordpress_dbserver = "127.0.0.1"
wordpress_secure_auth_key = "change me4"
wordpress_logged_in_key = "change me5"
wordpress_nonce_key = "change me6"

#
# install daemon
#

mysql_service "default" do
  port mysql_port
  version "5.6"
  initial_root_password mysql_root_password
  action [:create, :start]
end

mysql_config "default" do
  notifies :restart, "mysql_service[default]"
end

#
# user+database creation preconditions
#

mysql_client "default"

include_recipe "build-essential"

chef_gem "mysql2" do
  compile_time false
end

#
# create user+database
#

root_connection = {
  host: "127.0.0.1",
  port: mysql_port,
  username: "root",
  password: mysql_root_password,
}

mysql_database wordpress_db do
  connection root_connection
end

mysql_database_user wordpress_user do
  connection root_connection
  password wordpress_password
  database_name wordpress_db
  host "%"
  require_ssl false
  privileges [ :all ]
  action [ :create, :grant ]
end