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

Question

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 1

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

Answer 2

This is an option which needs to be set in the MySQL configuration file on the server. It can't be set by client APIs such as MySQLdb. This is because of the potential security implications.

That is, I may want to deny access from a particular hostname. With skip-name-resolve enabled, this won't work. (Admittedly, access control via hostname is probably not the best idea anyway.)