Need help how to create database in mysql via chef .Iam able to install mysql and now i need to create database i don’t know the syntax how to create database.Thanks .
Hello. To create a new mysql database use:
CREATE DATABASE `name_database`
Then create a table:
CREATE TABLE `name_of_table` (
`id` INT(1) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
`column2` DATE NOT NULL,
`column3` VARCHAR(255) NOT NULL
) ;