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

/*
  $Id$

  BioArray Software Environment (BASE) - http://base.thep.lu.se/
  Copyright (C) 2002-2004 Lao Saal, Carl Troein,
  Johan Vallon-Christersson, Jari Häkkinen, Nicklas Nordborg

  This file is part of BASE.

  BASE is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  as published by the Free Software Foundation; either version 2
  of the License, or (at your option) any later version.

  BASE is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place - Suite 330,
  Boston, MA  02111-1307, USA.

  ==============================================================
  
  A simple sequence of SQL commands that create a Base2 database
  for the MySQL database.
  
  This file should be executed by the mysql command-line tool:
  
  mysql -uroot -p < createdb.mysql.sql

  Before executing this file it is a good idea to change the
  default password to something else. Do not forget to
  make the corresponding change in your base.config file.
  
  It is also possible to change the username (base2user)
  database name (base2) and dynamic database name (base2dynamic) 
  to something else. If yo do, do not forget to make the 
  corresponding changes in your base.config file.
*/

CREATE DATABASE `base2` DEFAULT CHARACTER SET utf8;
CREATE DATABASE `base2dynamic` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `base2`.* TO 'base2user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON `base2dynamic`.* TO 'base2user'@'localhost';

/*For MySql 5.0 only
SET PASSWORD FOR 'base2user'@'localhost' = OLD_PASSWORD('password');
FLUSH PRIVILEGES;*/