Re: Newbie question: first project can't connect to MySQL

I got the same problem. I solved it just now.

http://stackoverflow.com/questions/18150858/operationalerror-2002-cant-connect-to-local-mysql-server-through-socket-v

On Thursday, February 5, 2009 1:41:21 AM UTC+8, Kevin Audleman wrote:

Hello everyone,

I am running through the tutorial and setting up my first django
project. Quite exciting! However I have run into trouble connecting to
MySQL. My settings.py file looks like this:

DATABASE_ENGINE = 'mysql'           # 'postgresql_psycopg2',
'postgresql', 'mysql', 'sqlite3' or 'oracle'.
DATABASE_NAME = 'test'             # Or path to database file if using
sqlite3.
DATABASE_USER = 'root'             # Not used with sqlite3.
DATABASE_PASSWORD = ''         # Not used with sqlite3.
DATABASE_HOST = ''             # Set to empty string for localhost.
Not used with sqlite3.
DATABASE_PORT = ''             # Set to empty string for default. Not
used with sqlite3.

Yes, the username is 'root' and there is no password. This is on my
local machine (OS X 10.5) so it doesn't matter.

When I run...

$ python manage.py syncdb

I get the following...

Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "/Library/Python/2.5/site-packages/django/core/management/
__init__.py", line 340, in execute_manager
    utility.execute()
  File "/Library/Python/2.5/site-packages/django/core/management/
__init__.py", line 295, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Library/Python/2.5/site-packages/django/core/management/
base.py", line 192, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/Library/Python/2.5/site-packages/django/core/management/
base.py", line 218, in execute
    self.validate()
  File "/Library/Python/2.5/site-packages/django/core/management/
base.py", line 246, in validate
    num_errors = get_validation_errors(s, app)
  File "/Library/Python/2.5/site-packages/django/core/management/
validation.py", line 65, in get_validation_errors
    connection.validation.validate_field(e, opts, f)
  File "/Library/Python/2.5/site-packages/django/db/backends/mysql/
validation.py", line 8, in validate_field
    db_version = connection.get_server_version()
  File "/Library/Python/2.5/site-packages/django/db/backends/mysql/
base.py", line 277, in get_server_version
    self.cursor()
  File "/Library/Python/2.5/site-packages/django/db/backends/
__init__.py", line 56, in cursor
    cursor = self._cursor(settings)
  File "/Library/Python/2.5/site-packages/django/db/backends/mysql/
base.py", line 262, in _cursor
    self.connection = Database.connect(**kwargs)
  File "/Users/audleman/django_projects/pollster/__init__.py", line
74, in Connect

  File "/Library/Python/2.5/site-packages/MySQL_python-1.2.2-py2.5-
macosx-10.5-i386.egg/MySQLdb/connections.py", line 170, in __init__
_mysql_exceptions.OperationalError: (2002, "Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2)")


I'm not exactly sure what this socket is or why django can't find it.
One thought is that I installed LAMP on my machine using XAMPP, which
puts everything in the /Applications/xampp directory. Poking around, I
managed to find a mysql.sock file here:

/Applications/xampp/xamppfiles/var/mysql/mysql.sock

Assuming this is the correct socket, how do I tell django where to
find it?

Thanks,
Kevin

--
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.
For more options, visit https://groups.google.com/groups/opt_out.