Activities

December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

Mysql on Windows : Can’t get hostname for your address

I’m getting this error message while I’m accessing remote mysql database which was running on WAMP.

Simple fix is to add “skip-name-resolve” in my.cnf file which will be shown in MySQL installation directory.

Since the MySQL server is using WAMP environment, You need to put the same line inside [wampmysqld].

The my.cnf file location will be the “C:\wamp\bin\mysql\mysql5.5.8\my.cnf

Eg:

[wampmysqld]
port        = 3306
socket      = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=c:/wamp/bin/mysql/mysql5.5.8
log-error=c:/wamp/logs/mysql.log
datadir=c:/wamp/bin/mysql/mysql5.5.8/data
skip-name-resolve

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>