Skip to content

Latest commit

 

History

History
49 lines (38 loc) · 2.49 KB

resource_mariadb_database.md

File metadata and controls

49 lines (38 loc) · 2.49 KB

mariadb_database

Manage databases and execute SQL queries on them. It works by establishing a control connection to the MariaDB server using the mariadb 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 node['mariadb']['server_root_password'] no
host String host to connect to localhost no
port String port of the host to connect to node['mariadb']['mysqld']['port'] 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 Proc # the SQL query to execute no

When host has the value localhost, it will try to connect using the Unix socket defined in node['mariadb']['client']['socket'], or TCP/IP if no socket is defined.

Examples

# Create a database
mariadb_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
mariadb_database 'baz' do
  action :drop
end

# Query a database
mariadb_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.