How to use the option skip-name-resolve when using MySQLdb for Python?

python mysql mysql-python resolve
CreeTar picture CreeTar · Jul 12, 2011 · Viewed 59.1k times · Source

I try to connect to database in a domain from my virtual machine. It works on XP, but somehow does not work on Win7 and quitting with: "OperationalError: (1042, "Can't get hostname for your address")"

Now I tried disable Firewall and stuff, but that doesn't matter anyway. I don't need the DNS resolving, which will only slow everything down. So I want to use the option "skip-name-resolve", but there is no my.ini or my.cnf when using MySQLdb for Python, so how can I still use this option?

Thanks for your help -Alex

Answer

Ranzit picture Ranzit · Apr 3, 2013

Add the following line(skip-name-resolve) in the /etc/mysql/my.cnf file

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-name-resolve

And restart the mysql server

Related questions

Installing specific package versions with pip

I'm trying to install version 1.2.2 of the MySQL_python adaptor, using a fresh virtualenv created with the --no-site-packages option. The current version shown in PyPi is 1.2.3. Is there a way to install the older version? I found an article stating …

Read More
ImportError: No module named MySQLdb

I am referring the following tutorial to make a login page for my web application. http://code.tutsplus.com/tutorials/intro-to-flask-signing-in-and-out--net-29982 I am having issue with the database. I am getting an ImportError: No module named MySQLdb when I execute …

Read More
Install mysql-python (Windows)

I've spent hours trying to make Django work on my computer. The problem is that I can't install the mysql-python package. I'm running Windows 7 64bit. This is what I've tried: I have downloaded easy_install I have downloaded Cygwin64 to …

Read More