Re: OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

try to define the parameters so

'ENGINE': 'django.db.backends.mysql',       'NAME': 'yourdbname',                            'USER': 'root',                            'PASSWORD': 'your password',               'HOST': '127.0.0.1',                       'PORT': '3306', 

El domingo, 6 de enero de 2013 05:42:21 UTC-5, ANKIT BAGARIA escribió:

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.

        'NAME': 'django',                      # Or path to database file if using sqlite3.

        'USER': 'name',                      # Not used with sqlite3.

        'PASSWORD': 'pass',                  # Not used with sqlite3.

        'HOST': '/var/run/mysql',           # Set to empty string for localhost. Not used with sqlite3.

        'PORT': '',                      # Set to empty string for default. Not used with sqlite3.

    }

}

this is my setting in settings.py file. I have Mysql server running .Now I run python manage.py shell to start python interpreter. Then in the interreter I type the following command to check the connection to database:

>>>from django.db import connection

>>>cursor = connection.cursor()

and it gives me the following error:

Traceback (most recent call last):

  File "<console>", line 1, in <module>

  File "C:\Python27\lib\site-packages\django\db\backends\__init__.py", line 306,

 in cursor

    cursor = self.make_debug_cursor(self._cursor())

  File "C:\Python27\lib\site-packages\django\db\backends\mysql\base.py", line 38

7, in _cursor

    self.connection = Database.connect(**kwargs)

  File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect

    return Connection(*args, **kwargs)

  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __in

it__

    super(Connection, self).__init__(*args, **kwargs2)

OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

 I am using windows 7.

please help me fix it. it is driving me crazy. I have googled it, gone through different forums but am not able to fix it. Please help me.

thankyou.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.