개발개발/Python

Python can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock

꾸냥 2010. 6. 29. 16:15
python 으로 mysql 를 접근할때

>>> db = MySQLdb.connect(host=dbcon['host'],user=dbcon['user'],passwd=dbcon['passwd'],db=dbcon['db'])
Traceback (most recent call last):
  File "", line 1, in ?
  File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 75, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 164, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")


메시지를 출력하면서 작동 안됨

핵심은 mysql.sock 을 찾을 수 없다는 것인데 이럴땐

>>> db = MySQLdb.connect(host=dbcon['host'],user=dbcon['user'],passwd=dbcon['passwd'],db=dbcon['db'],unix_socket="/tmp/mysql.sock")


로 연결해주면 해결. unix_socket 에 sock 위치를 지정해준다. /etc/my.cnf 에 나와있음

반응형