aboutsummaryrefslogtreecommitdiffstats
path: root/etherpad/bin/setup-mysql-db.sh
blob: d823a9eee405b1fa8467308885d29650ca315179 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
#!/bin/bash -e

#  Copyright 2009 Google Inc.
#  
#  Licensed under the Apache License, Version 2.0 (the "License");
#  you may not use this file except in compliance with the License.
#  You may obtain a copy of the License at
#  
#       http://www.apache.org/licenses/LICENSE-2.0
#  
#  Unless required by applicable law or agreed to in writing, software
#  distributed under the License is distributed on an "AS-IS" BASIS,
#  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#  See the License for the specific language governing permissions and
#  limitations under the License.

if [ `whoami` != "root" ]; then
  echo "Must run as root, i.e., sudo $0"
  exit 1
fi

db="etherpad"

echo "Creating etherpad ${db}..."
echo "create database ${db};" | ${mysql} -u root

echo "Granting priviliges..."
echo "grant all privileges on ${db}.* to 'etherpad'@'localhost' identified by 'password';" | ${mysql} -u root

echo "Success"