summaryrefslogtreecommitdiff
path: root/contrib/create-database.sql
blob: 8c31b9098840d010a716d422679c3876887fd0ad (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
--
-- Current Database: mysql
--
use mysql;

CREATE DATABASE IF NOT EXISTS xxv;

use xxv;

-- Create a mysql-Account : Adjust User and Password here and add this to xxvd.cfg 
-- [General]
-- DSN=DBI:mysql:database=xxv;host=localhost;port=3306
-- PWD=password
-- USR=username

-- The first line is useful for granting access to user xxv on all computers in a network.
/* grant all privileges on xxv.* to username@'%' IDENTIFIED BY 'password'; */

-- Grant access to user xxv on the local machine with password 'xxv'
grant all privileges on xxv.* to xxv@localhost IDENTIFIED BY 'xxv';

flush privileges;