h1. mysql

 "home":../index.html > "recipes":index.html >  mysql  


h2. Namespaces

* "mysql:centos":mysql-centos.html (1) 
* "mysql:monit":mysql-monit.html (1) 


h2. Tasks

* "mysql:setup":#mysql:setup 


h2. Task documentation

h3(#mysql:setup). mysql:setup

Create database, database user, and set grant permissions.

*db_name*: Database name (application).

*db_user*: Database user (application).
  
*db_pass*: Database password (application).

*mysql_grant_locations*: Grant locations. _Defaults to localhost_

@set :mysql_grant_locations, [ "localhost", "192.168.1.111" ]@

*mysql_grant_priv_type*: Grant privilege types. _Defaults to ALL_

@set :mysql_grant_priv_type, "ALL"@

*mysql_admin_password*: Mysql admin password (to use to connect). Defaults to password prompt.

@set :mysql_admin_password, prompt.password('Mysql admin password: '))@