THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!

Database setup

Created by Josh Thompson, last modified by Andy Kurth on Jul 01, 2009

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Prerequisites

You should have mysql server 5.x installed. If mysql server is not installed:

yum install mysql-server -y
/sgin/chkconfig --level 345 mysqld on/sbin/service mysqld start

Setting Up the Database for VCL

create a database in mysql named for use with VCL
```
CREATE DATABASE vcl;
```

create a user with SELECT, INSERT, UPDATE, and DELETE privileges on the database you just created

GRANT SELECT,INSERT,UPDATE,DELETE ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';

get vcl.sql file

svn export https://svn.apache.org/repos/asf/incubator/vcl/trunk/mysql/vcl.sql

import vcl.sql file into database
```
mysql vcl < vcl.sql
```

No labels