1477 |
19 Oct 05 |
nicklas |
1 |
/* |
1477 |
19 Oct 05 |
nicklas |
$Id$ |
1477 |
19 Oct 05 |
nicklas |
3 |
|
3675 |
16 Aug 07 |
jari |
Copyright (C) 2005 Nicklas Nordborg |
4889 |
06 Apr 09 |
nicklas |
Copyright (C) 2006 Jari Häkkinen, Martin Svensson |
1477 |
19 Oct 05 |
nicklas |
6 |
|
2304 |
22 May 06 |
jari |
This file is part of BASE - BioArray Software Environment. |
2304 |
22 May 06 |
jari |
Available at http://base.thep.lu.se/ |
1477 |
19 Oct 05 |
nicklas |
9 |
|
1477 |
19 Oct 05 |
nicklas |
BASE is free software; you can redistribute it and/or |
1477 |
19 Oct 05 |
nicklas |
modify it under the terms of the GNU General Public License |
4475 |
05 Sep 08 |
jari |
as published by the Free Software Foundation; either version 3 |
1477 |
19 Oct 05 |
nicklas |
of the License, or (at your option) any later version. |
1477 |
19 Oct 05 |
nicklas |
14 |
|
1477 |
19 Oct 05 |
nicklas |
BASE is distributed in the hope that it will be useful, |
1477 |
19 Oct 05 |
nicklas |
but WITHOUT ANY WARRANTY; without even the implied warranty of |
1477 |
19 Oct 05 |
nicklas |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
1477 |
19 Oct 05 |
nicklas |
GNU General Public License for more details. |
1477 |
19 Oct 05 |
nicklas |
19 |
|
1477 |
19 Oct 05 |
nicklas |
You should have received a copy of the GNU General Public License |
4509 |
11 Sep 08 |
jari |
along with BASE. If not, see <http://www.gnu.org/licenses/>. |
1477 |
19 Oct 05 |
nicklas |
22 |
|
1477 |
19 Oct 05 |
nicklas |
23 |
============================================================== |
1477 |
19 Oct 05 |
nicklas |
24 |
|
1477 |
19 Oct 05 |
nicklas |
A simple sequence of SQL commands that create a Base2 database |
1477 |
19 Oct 05 |
nicklas |
for the MySQL database. |
1477 |
19 Oct 05 |
nicklas |
27 |
|
1477 |
19 Oct 05 |
nicklas |
This file should be executed by the mysql command-line tool: |
1477 |
19 Oct 05 |
nicklas |
29 |
|
1477 |
19 Oct 05 |
nicklas |
mysql -uroot -p < createdb.mysql.sql |
1477 |
19 Oct 05 |
nicklas |
31 |
|
1477 |
19 Oct 05 |
nicklas |
Before executing this file it is a good idea to change the |
1477 |
19 Oct 05 |
nicklas |
default password to something else. Do not forget to |
1477 |
19 Oct 05 |
nicklas |
make the corresponding change in your base.config file. |
1477 |
19 Oct 05 |
nicklas |
35 |
|
1477 |
19 Oct 05 |
nicklas |
It is also possible to change the username (base2user) |
1477 |
19 Oct 05 |
nicklas |
database name (base2) and dynamic database name (base2dynamic) |
1477 |
19 Oct 05 |
nicklas |
to something else. If yo do, do not forget to make the |
1477 |
19 Oct 05 |
nicklas |
corresponding changes in your base.config file. |
1477 |
19 Oct 05 |
nicklas |
40 |
*/ |
1477 |
19 Oct 05 |
nicklas |
CREATE DATABASE `base2` DEFAULT CHARACTER SET utf8; |
1477 |
19 Oct 05 |
nicklas |
CREATE DATABASE `base2dynamic` DEFAULT CHARACTER SET utf8; |
1477 |
19 Oct 05 |
nicklas |
43 |
|
1477 |
19 Oct 05 |
nicklas |
GRANT ALL ON `base2`.* TO 'base2user'@'localhost' IDENTIFIED BY 'password'; |
1477 |
19 Oct 05 |
nicklas |
GRANT ALL ON `base2dynamic`.* TO 'base2user'@'localhost'; |