summaryrefslogtreecommitdiff
path: root/scripts/createdb.mysql
blob: 7ccdc89f2503b685c6e0f8d8e9c70e6301750e57 (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;