source: trunk/misc/sql/createdb.mysql.sql @ 1477

Last change on this file since 1477 was 1477, checked in by Nicklas Nordborg, 17 years ago

Added db.dynamic.catalog and db.dynamic.schema options.
Added database creation SQL for Mysql and Postgres.

File size: 1.8 KB
Line 
1/*
2  $Id$
3
4  BioArray Software Environment (BASE) - http://base.thep.lu.se/
5  Copyright (C) 2002-2004 Lao Saal, Carl Troein,
6  Johan Vallon-Christersson, Jari Häkkinen, Nicklas Nordborg
7
8  This file is part of BASE.
9
10  BASE is free software; you can redistribute it and/or
11  modify it under the terms of the GNU General Public License
12  as published by the Free Software Foundation; either version 2
13  of the License, or (at your option) any later version.
14
15  BASE is distributed in the hope that it will be useful,
16  but WITHOUT ANY WARRANTY; without even the implied warranty of
17  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18  GNU General Public License for more details.
19
20  You should have received a copy of the GNU General Public License
21  along with this program; if not, write to the Free Software
22  Foundation, Inc., 59 Temple Place - Suite 330,
23  Boston, MA  02111-1307, USA.
24
25  ==============================================================
26 
27  A simple sequence of SQL commands that create a Base2 database
28  for the MySQL database.
29 
30  This file should be executed by the mysql command-line tool:
31 
32  mysql -uroot -p < createdb.mysql.sql
33
34  Before executing this file it is a good idea to change the
35  default password to something else. Do not forget to
36  make the corresponding change in your base.config file.
37 
38  It is also possible to change the username (base2user)
39  database name (base2) and dynamic database name (base2dynamic)
40  to something else. If yo do, do not forget to make the
41  corresponding changes in your base.config file.
42*/
43
44CREATE DATABASE `base2` DEFAULT CHARACTER SET utf8;
45CREATE DATABASE `base2dynamic` DEFAULT CHARACTER SET utf8;
46
47GRANT ALL ON `base2`.* TO 'base2user'@'localhost' IDENTIFIED BY 'password';
48GRANT ALL ON `base2dynamic`.* TO 'base2user'@'localhost';
Note: See TracBrowser for help on using the repository browser.