blob: 2d3c18332b9144b7c64888ee12286ce05b9b89e0 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
# $Id$
#
# This script is responsible for creating the database used by the
# portal gui. Look in the settings.py file for the user and password.
# n.b. The configure script generates a random password.
#
import getpass, MySQLdb
from django.conf import settings
dbname = settings.DATABASES['default']['NAME']
dbuser = settings.DATABASES['default']['USER']
dbpass = settings.DATABASES['default']['PASSWORD']
print """WARNING!!!
WARNING!!!
WARNING!!!
About to destroy and recreate the database named "%s" and give access
to the user named "%s".
""" % (dbname, dbuser)
passwd = getpass.getpass('Please enter your MySQL root password: ')
db = MySQLdb.connect(user='root', passwd=passwd)
c = db.cursor()
c.execute('DROP DATABASE IF EXISTS %s' % dbname)
c.execute('CREATE DATABASE %s CHARACTER SET utf8' % dbname)
c.execute('GRANT ALL ON %s.* TO %s@localhost identified by %%s' % (dbname, dbuser), (dbpass,))
|
