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

Last change on this file since 2304 was 2304, checked in by Jari Häkkinen, 16 years ago

Changed copyright statement.

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