MySQL for Python on Windows via Xampp

Question

I've MySQL running through XAMPP, and I've also installed MySQLdb for python installed. I, however cannot figure out a way of using my XAMPP's MySQL for Python. Each time I execute python manage.py runserver it shows an error:

..2.4c1-py2.7-win32.egg.tmp\MySQLdb\connections.py", line 187, in __init__ _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

I'm new to Python and these are the settings in settings.py file:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': 'tester',                      # Or path to database file if using sqlite3.
        'USER': 'root',                      # 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.
    }
}

I'm using Django. If I use SQLite3 instead of MySQL, it works fine. But I wanted to use MySQL.

EDIT#1

MySQL is using port: 3306. How do I get them working?

May seem a trivial question, but did you check that MySQL server was actually started and running on your system before trying to connect to the database? — dariyoosh
– dariyoosh, Commented Dec 20, 2012 at 9:41
Yes. I checked that. MySQL was running when I executed python manage.py runserver command. — xan
– xan, Commented Dec 20, 2012 at 9:44
You have misunderstood Django's documentation. At no point does it say that it looks for MySQL on port 3306. Port 8000 is where the web application itself is served by the development server by default. And you should notice that in the code you posted above, there is an (empty) entry for PORT. Did you try filling that in? — Daniel Roseman
– Daniel Roseman, Commented Dec 20, 2012 at 9:59
@DanielRoseman:Yes, I filled it in. I tried with 3306 and 8000 both. Still no use. — xan
– xan, Commented Dec 20, 2012 at 10:03

xan · Accepted Answer · 2013-06-20 20:27:48Z

7

After 5-6 hours of trying, I finally got it working.

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

run command in cmd: python manage.py runserver, and open the webpage.

edited Jun 20, 2013 at 20:27

answered Dec 20, 2012 at 11:57

xan

4,72614 gold badges53 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Varun Bajaj · Accepted Answer · 2012-12-20 09:45:17Z

2

Can you check the port because mysql uses default port as 3306 (if not get change manually)

answered Dec 20, 2012 at 9:45

Varun Bajaj

1,0438 silver badges17 bronze badges

1 Comment

xan Over a year ago

Yes. I just found that. MySQL is using port 3306. But Django's documentation uses 8000. How do I get them working?

Rickard Zachrisson · Accepted Answer · 2012-12-20 09:45:25Z

2

You most likely need to add a port where mysql is running. This could be that xampp set mysql to another port than standard 3306.

Can you connect to mysql outside django?

You should find some mysql.exe file inside xampp directory I guess. If you navigate to that directory through terminal and then run mysql.exe -uroot -p . Add password, which is most likely a blank password.

answered Dec 20, 2012 at 9:45

Rickard Zachrisson

9857 silver badges11 bronze badges

7 Comments

xan Over a year ago

Thankyou. I found that the error may be due to ports. How do I change the ports?MySQL is using port 3306. But Django's documentation uses 8000. How do I get them working?

Rickard Zachrisson Over a year ago

8000 is used for djangos wsgi. So localhost:8000 will be pointed to django. If you manage.py runserver 0.0.0.0 you get localhost without port. If you run manage.py runserver 0.0.0.0:9999 you get localhost:9999

xan Over a year ago

So I now ran python manage.py runserver 0.0.0.0:3306, and navigated to localhost:3306-->Still the webpage is not getting displayed.

Rickard Zachrisson Over a year ago

3306 is the port the database uses as standard. 0.0.0.0:XXXX is the port the webserver uses. In your DATABASES above you have a key called PORT. You need to add the port where mysql runs. Try my suggestion on opening the database through cms that I suggested above.

xan Over a year ago

I've changed the XAMPP MySQL port to 8000. [Its working]. Now again if I try python manage.py runserver or python manage.py runserver 0.0.0.0:8000 [I've tried both], still the page doesn't open.

|

Collectives™ on Stack Overflow

MySQL for Python on Windows via Xampp

3 Answers 3

Comments

1 Comment

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related