Thursday, November 10, 2011

Setting up mysql on windows with Django

Install mysql from http://www.mysql.com/

Then you'll need a mysql drive thingo as standard django does not come with it.

Install the windows exe install from http://www.codegood.com/archives/129.

Setup your settings.py as follows:

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'wordy',
'USER': 'wordy',
'PASSWORD': 'nooble',
'HOST': 'localhost', # Set to empty string for localhost. Not used with sqlite3.
'PORT': '', # Set to empty string for default. Not used with sqlite3.
}
}

Then create your user, my example is wordy, using mysql workbench. Put localhost into the 'limit connectivity to hosts matching' field, do not use the default of %.

No comments:

Post a Comment