summaryrefslogtreecommitdiff
path: root/contrib/create-database.sql
diff options
context:
space:
mode:
authorAndreas Brachold <vdr07@deltab.de>2007-08-13 18:41:27 +0000
committerAndreas Brachold <vdr07@deltab.de>2007-08-13 18:41:27 +0000
commitbcbf441e09fb502cf64924ff2530fa144bdf52c5 (patch)
treef377707a2dac078db8cd0c7d7abfe69ac1006d71 /contrib/create-database.sql
downloadxxv-bcbf441e09fb502cf64924ff2530fa144bdf52c5.tar.gz
xxv-bcbf441e09fb502cf64924ff2530fa144bdf52c5.tar.bz2
* Move files to trunk
Diffstat (limited to 'contrib/create-database.sql')
-rw-r--r--contrib/create-database.sql22
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;