Skip to content

Latest commit

 

History

History
49 lines (38 loc) · 2.44 KB

resource_mysql_database.md

File metadata and controls

49 lines (38 loc) · 2.44 KB
Raw

mysql_database

Manage MySQL databases and execute SQL queries on them. It works by establishing a control connection to the MySQL server using the MySQL client (be sure it is installed before using this resource).

Actions

  • create - (default) to create a named database
  • drop - to drop a named database
  • query - to execute a SQL query

Properties

Name Types Description Default Required?
user String the username of the control connection root no
password String password of the user used to connect to no
host String host to connect to localhost no
port String port of the host to connect to 3306 no
database_name String the name of the database to manage name if not specified no
encoding String utf8 no
collation String utf8_general_ci no
sql String the SQL query to execute no

When host has the value localhost, it will try to connect using a Unix socket, or TCP/IP if no socket is defined.

Examples

# Create a database
mysql_database 'wordpress-cust01' do
  host '127.0.0.1'
  user 'root'
  password node['wordpress-cust01']['mysql']['initial_root_password']
  action :create
end

# Drop a database
mysql_database 'baz' do
  action :drop
end

# Query a database
mysql_database 'flush the privileges' do
  sql 'flush privileges'
  action :query
end

The query action will NOT select a database before running the query, nor return the actual results from the SQL query.