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.

Reply via email to