summaryrefslogtreecommitdiff
path: root/scripts/createdb.mysql
blob: 68c12d75c13b8f1a9f594ee89daed8621e211419 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Creates DB and opens it to any user
-- Run this mysql macro as root!

DROP DATABASE IF EXISTS GiantDisc;
CREATE DATABASE GiantDisc;

use GiantDisc;

-- The first line is useful for granting access to user vdr on all computers in a network.
-- grant all privileges on GiantDisc.* to vdr@'%';

-- Grant access to user vdr on the local machine
grant all privileges on GiantDisc.* to vdr@localhost;