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

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

Changing the pesky "a (ä) character to a.

File size: 1.8 KB
Line 
1/*
2  $Id$
3
4  Copyright (C) 2005 Nicklas Nordborg
5  Copyright (C) 2006 Jari Hakkinen, 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 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';
49
50/*For MySql 5.0 only
51SET PASSWORD FOR 'base2user'@'localhost' = OLD_PASSWORD('password');
52FLUSH PRIVILEGES;*/
Note: See TracBrowser for help on using the repository browser.