contrib/create-database.sql


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

--
-- Current Database: mysql
--
use mysql;

-- Create mysql-Database with latin1
CREATE DATABASE IF NOT EXISTS xxv DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;

-- Create mysql-Database with utf8
-- CREATE DATABASE IF NOT EXISTS xxv DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

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;