diff options
| author | Andreas Brachold <vdr07@deltab.de> | 2007-08-13 18:41:27 +0000 |
|---|---|---|
| committer | Andreas Brachold <vdr07@deltab.de> | 2007-08-13 18:41:27 +0000 |
| commit | bcbf441e09fb502cf64924ff2530fa144bdf52c5 (patch) | |
| tree | f377707a2dac078db8cd0c7d7abfe69ac1006d71 /contrib/create-database.sql | |
| download | xxv-bcbf441e09fb502cf64924ff2530fa144bdf52c5.tar.gz xxv-bcbf441e09fb502cf64924ff2530fa144bdf52c5.tar.bz2 | |
* Move files to trunk
Diffstat (limited to 'contrib/create-database.sql')
| -rw-r--r-- | contrib/create-database.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/contrib/create-database.sql b/contrib/create-database.sql new file mode 100644 index 0000000..8c31b90 --- /dev/null +++ b/contrib/create-database.sql @@ -0,0 +1,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; |
