blob: 90c987984f0270b0de7b8a8a3030aa58c2bbdbe1 [file] [log] [blame]
Taka Cho9658ce82020-12-10 14:34:18 -05001#!/bin/sh
Jakub Latusekd71d26c2020-10-21 13:36:29 +02002{{/*
mayankg2703ced85142018-03-20 05:42:53 +00003# Copyright © 2017 Amdocs, Bell Canada, AT&T
jhhd4258672020-08-09 12:08:08 -05004# Modifications Copyright © 2018, 2020 AT&T Intellectual Property
mayankg2703ced85142018-03-20 05:42:53 +00005#
6# Licensed under the Apache License, Version 2.0 (the "License");
7# you may not use this file except in compliance with the License.
8# You may obtain a copy of the License at
9#
10# http://www.apache.org/licenses/LICENSE-2.0
11#
12# Unless required by applicable law or agreed to in writing, software
13# distributed under the License is distributed on an "AS IS" BASIS,
14# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
15# See the License for the specific language governing permissions and
16# limitations under the License.
Jakub Latusekd71d26c2020-10-21 13:36:29 +020017*/}}
mayankg2703ced85142018-03-20 05:42:53 +000018
Sylvain Desbureaux4898dc02019-11-14 13:35:13 +010019mysql() { /usr/bin/mysql -h ${MYSQL_HOST} -P ${MYSQL_USER} "$@"; };
jhhd4258672020-08-09 12:08:08 -050020
sebdet5c449882021-01-13 11:35:56 +010021for db in support onap_sdk log migration operationshistory10 pooling policyadmin policyclamp operationshistory
mayankg2703ced85142018-03-20 05:42:53 +000022do
23 mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "CREATE DATABASE IF NOT EXISTS ${db};"
24 mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "GRANT ALL PRIVILEGES ON \`${db}\`.* TO '${MYSQL_USER}'@'%' ;"
25done
26
27mysql -uroot -p"${MYSQL_ROOT_PASSWORD}" --execute "FLUSH PRIVILEGES;"