[Solved]-Django, phpmyadmin and mysql?

You can definitely manage Mysql through the XAMPP interface. Try setting the DB_HOST in settings.py to “localhost”. If it doesn’t work, try “127.0.0.1”. This is typically caused by the python-mysql module expecting the mysql unix socket to be in another place than it is. Actually, I’m unsure if the mysql server uses a unix socket on Windows. Anyway, one of both should work 🙂
You can use the credentials you use to login with phpmyAdmin also for Django. Many consider it bad style to use root for non-administration tasks (and I agree), but for starters and on your development machine it isn’t too big of an issue.
phpMyAdmin should work out of the box with your django-managed databases.

My database settings.py block for mysql looks something like this:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': 'DBNAME',                      # Or path to database file if using sqlite3.
        'USER': 'USER',                      # Not used with sqlite3.
        'PASSWORD': 'PASSWORD',                  # Not used with sqlite3.
        'HOST': '',                      # Set to empty string for localhost. Not used with sqlite3.
        'PORT': '',                      # Set to empty string for default. Not used with sqlite3.
    }
}

This is for django 1.2 and above. Replace DBNAME, USER and PASSWORD with the respective values and try ‘127.0.0.1’ as HOST if you run into problems. Obviously, you’d need to run ‘manage.py syncdb’ as you did with sqlite before you can use it.