MySQL connection error with Django

Question

I get the following error when I run the Django command "python manage.py syncdb"

_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)

I have installed python, django and py26-mysql using macports. I ran in to issues installing mysql through macports so I installed a standalone version.

What do I need to change so that django uses my standalone version of mysql and not macports version of mysql. I have verified that only standalone server is running when I execute this command.

Thanks

Jack M. · Accepted Answer · 2011-05-02 19:49:49Z

5

Use the HOST setting in your settings file:

"HOST": '/path/to/your/socket.sock'

answered May 2, 2011 at 19:49

Jack M.

32.3k7 gold badges58 silver badges67 bronze badges

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

2 Comments

arjunurs Over a year ago

Thanks, I tried the following and it worked "HOST": '127.0.0.1'

nicorellius Over a year ago

This took me a while to figure out - thanks for making it easier ;-)

Collectives™ on Stack Overflow

MySQL connection error with Django

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related