Thanks for solution. I have also encounter similar problem before. I have found the name for socket file appeared in exception content is different from which MySQL server using, but don't know how where to indicate the socket file name.
/etc/mysql/my.cnf 2011/3/2 draix <martin.a...@gmail.com> > Hey Pulkit, > > I've had this error a couple of times too. Check the location of your > MySQL socket, maybe it's different to '/var/run/mysqld/mysqld.sock'. > You can do it checking /etc/mysql/my.cnf. After that, just update > DATABASE_HOST in settings.py and add the path to the new socket. > > PS: you can also use "python manage.py dbshell" to test your DB > access. > > Cheers, > Martin > > On 28 feb, 16:19, Pulkit Mehrotra <mehrotra.pul...@gmail.com> wrote: > > OS: Ubuntu 10.04 > > I am learning web developing with Django.I downloaded and installed > > python-mysql but i couldn't connect.I think problem is database > > settings. > > Here is the process: > > > > django-admin.py startproject mysite #creating a project and a mysite > > folder > > > > files in 'mysite' folder: > > /__init__.py > > /urls.py > > /manage.py > > /views.py > > /settings.py > > > > Then i edited the 'settings.py' file.There are alse database settings > > in it. > > > > Here are the settings: > > > > DATABASE_ENGINE = 'mysql' > > DATABASE_NAME = 'mydb' > > DATABASE_USER = 'me' > > DATABASE_PASSWORD = 'pwd' > > DATABASE_HOST = '' > > DATABASE_PORT = '' > > > > then i write the codes below with terminal: > > > > python manage.py shell > > > > from django.db import connection > > cursor=connection.cursor() > > > > Then the error occurs as: > > > > Traceback (most recent call last): > > File "<console>", line 1, in <module> > > File "/usr/lib/python2.5/site-packages/django/db/backends/mysql/ > > base.py", line 99, in cursor > > self.connection = Database.connect(**kwargs) > > File "/var/lib/python-support/python2.5/MySQLdb/__init__.py", line 74, > > in Connect > > return Connection(*args, **kwargs) > > File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line > > 170, in __init__ > > super(Connection, self).__init__(*args, **kwargs2) > > OperationalError: (2002, "Can't connect to local MySQL server through > > socket '/var/run/mysqld/mysqld.sock' (2)") > > > > It looks like that error occurs from DATABASE_HOST but i don't think > > so because when using MySQL DATABASE_HOST may be left blank > > -- > 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. > > -- 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.