On Sat, Sep 19, 2009 at 10:27 AM, When ideas fail <andrewkenyon...@gmail.com > wrote:
> > Hello, when I run python manage.py syncdb I get this error: > > File "C:\\Python26\lib\site-packages\MySQLdb\connections.py", lin > e 170, in __init__ > super(Connection, self).__init__(*args, **kwargs2) > _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL > server on 'lo > calhost' (10061)") > > I know mysql is working because I can connect using the client, I left > it running on the default port when I set it up. This is my > settings.py > > DATABASE_ENGINE = 'mysql' > DATABASE_NAME = 'mydb' > DATABASE_USER = 'root' > DATABASE_PASSWORD = '' > DATABASE_HOST = '' > DATABASE_PORT = '' > > This is on Vista so that could be messing about but i'd appreciate any > help, thanks. > > 10061 is Winsock connection refused so no program is listening on the TCP port/host you are trying to connect to. Double check that you have configured MySQL to enable TCP/IP networking. Note if you run through the configure wizard and do not enable TCP/IP networking, the generated config file will still allow the mysql client program to connect, since the wizard will write out a config that tells both the client and server pieces to use named pipes instead of TCP/IP. So being able to connect with the mysql client doesn't actually verify that you have enabled TCP/IP connections to the server. Karen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---