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

Last change on this file was 4889, checked in by Nicklas Nordborg, 13 years ago

References #1290: Change source files to UTF-8

Changed 'Hakkinen' to 'Häkkinen'.

File size: 1.7 KB
Line 
1/*
2  $Id$
3
4  Copyright (C) 2005 Nicklas Nordborg
5  Copyright (C) 2006 Jari Häkkinen, Martin Svensson
6
7  This file is part of BASE - BioArray Software Environment.
8  Available at http://base.thep.lu.se/
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 3
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 BASE. If not, see <http://www.gnu.org/licenses/>.
22
23  ==============================================================
24 
25  A simple sequence of SQL commands that create a Base2 database
26  for the MySQL database.
27 
28  This file should be executed by the mysql command-line tool:
29 
30  mysql -uroot -p < createdb.mysql.sql
31
32  Before executing this file it is a good idea to change the
33  default password to something else. Do not forget to
34  make the corresponding change in your base.config file.
35 
36  It is also possible to change the username (base2user)
37  database name (base2) and dynamic database name (base2dynamic)
38  to something else. If yo do, do not forget to make the
39  corresponding changes in your base.config file.
40*/
41CREATE DATABASE `base2` DEFAULT CHARACTER SET utf8;
42CREATE DATABASE `base2dynamic` DEFAULT CHARACTER SET utf8;
43
44GRANT ALL ON `base2`.* TO 'base2user'@'localhost' IDENTIFIED BY 'password';
45GRANT ALL ON `base2dynamic`.* TO 'base2user'@'localhost';
Note: See TracBrowser for help on using the repository browser.