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 %.