
SET @@SESSION.SQL_LOG_BIN=0;

CREATE USER 'sonar'@'%'   IDENTIFIED BY 'sonar';
CREATE USER 'redmine'@'%' IDENTIFIED BY 'redmine';

CREATE DATABASE `sonar`;
CREATE DATABASE `redmine`;

GRANT ALL ON `sonar`.*   TO 'sonar'@'%'   WITH GRANT OPTION;
GRANT ALL ON `redmine`.* TO 'redmine'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;


SET @@SESSION.SQL_LOG_BIN=0;

CREATE USER 'sonar'@'%'   IDENTIFIED BY 'sonar';
CREATE USER 'redmine'@'%' IDENTIFIED BY 'redmine';

CREATE DATABASE `sonar`   DEFAULT CHARACTER SET utf8  COLLATE utf8_generate_ci;
CREATE DATABASE `redmine` DEFAULT CHARACTER SET utf8  COLLATE utf8_generate_ci;

GRANT ALL ON `sonar`.*   TO 'sonar'@'%'   WITH GRANT OPTION;
GRANT ALL ON `redmine`.* TO 'redmine'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Add charset and collate to CREATE DATABASE clause
Add charset and collate to CREATE DATABASE clause

Signed-off-by: yatanokarasu <b27e66aa3bef217cd65b834332e749cf9c067c40@gmail.com>
