search

mwira / SEBC

0 stars 0 forks source link

Install Database #8

Open mwira opened 6 years ago

mwira commented 6 years ago

Started

mwira commented 6 years ago

Completed

Command for creating database: create database scm DEFAULT CHARACTER SET utf8; grant all on scm.* TO 'scm'@'%' IDENTIFIED BY 'scm_password';

create database rman DEFAULT CHARACTER SET utf8; grant all on rman.* TO 'rman'@'%' IDENTIFIED BY 'rman_password';

create database hive DEFAULT CHARACTER SET utf8; grant all on hive.* TO 'hive'@'%' IDENTIFIED BY 'hive_password';

create database sentry DEFAULT CHARACTER SET utf8; grant all on sentry.* TO 'sentry'@'%' IDENTIFIED BY 'sentry_password';

create database oozie default character set utf8; grant all privileges on oozie. to 'oozie'@'localhost' identified by 'oozie'; grant all privileges on oozie. to 'oozie'@'%' identified by 'oozie';

create database hue default character set utf8 default collate utf8_general_ci; grant all on hue.* to 'hue'@'%' identified by 'huepassword';

mwira commented 6 years ago

Wait for review