chef receipe将值添加到mysql表

mysql_service 'default' do
  port '3306'
  version '5.7'
  initial_root_password 'password'
  action [:create, :start]
end

mysql2_chef_gem 'default' do
  action :install
end

mysql_connection_info = {
  host: 'localhost',
  username: 'root',
  password: 'password',
}

mysql_database 'mydatabase' do
  connection mysql_connection_info
  action :create
end

mysql_database_user 'myuser' do
  connection mysql_connection_info
  password 'mypassword'
  database_name 'mydatabase'
  host '%'
  privileges [:all]
  action [:create, :grant]
end

mysql_query 'insert_data' do
  connection mysql_connection_info
  database_name 'mydatabase'
  sql "INSERT INTO mytable (column1, column2) VALUES ('value1', 'value2')"
  action :query
end