1#!/bin/bash
2#
3# Copyright 2021 The Sigstore Authors.
4#
5# Licensed under the Apache License, Version 2.0 (the "License");
6# you may not use this file except in compliance with the License.
7# You may obtain a copy of the License at
8#
9# http://www.apache.org/licenses/LICENSE-2.0
10#
11# Unless required by applicable law or agreed to in writing, software
12# distributed under the License is distributed on an "AS IS" BASIS,
13# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14# See the License for the specific language governing permissions and
15# limitations under the License.
16
17
18DB="test"
19USER="test"
20PASS="zaphod"
21ROOTPASS=""
22
23echo -e "Creating $DB database and $USER user account"
24
25
26mysql <<MYSQL_SCRIPT
27DROP DATABASE IF EXISTS $DB;
28CREATE DATABASE $DB;
29CREATE USER IF NOT EXISTS '$USER'@'localhost' IDENTIFIED BY '$PASS';
30GRANT ALL PRIVILEGES ON $DB.* TO '$USER'@'localhost';
31FLUSH PRIVILEGES;
32MYSQL_SCRIPT
33
34
35echo -e "Loading table data.."
36
37mysql -u $USER -p$PASS -D $DB < ./storage.sql
View as plain text