MySql database creation

general
,
1

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 .

2

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
 ) ;