Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've spent the whole day trying to fix this and it's driving me absolutely insane. I noticed the issue while trying to set up a remote mySQL server and then went from there. My manager can connect to the mySQL server at 192.168.242.26, using a mySQL GUI it shows him as being root@'192.168.242.26'. When I try the exact same GUI on the same server it shows me as root@'ThisisCompanyD-PC.local' (which apart from .local is my machines hostname).

I checked my HOSTS file and it doesn't refer to ThisisCompanyD-PC anywhere, it the usual 127.0.0.1 localhost loop and some specific ones for virtual hosts on a development server (the same one running mySQL).

My machine is running Vista, my manager has a XP machine and the server is running Ubuntu 10.04lts (Or Lucid Lynx if you prefer)

share|improve this question

2 Answers 2

Hi this should answer your question.

http://dev.mysql.com/doc/refman/5.0/en/dns.html

Also check the comments on the article.

share|improve this answer
    
Thank you, this lead me to the answer. I'll try and bump my reputation up to 15 so I can vote up! –  SuperCabbage Feb 21 '11 at 9:48
    
no points sad face :( –  pablo Feb 22 '11 at 10:22
up vote 0 down vote accepted

Turns out that adding skip-host-cache to the mySQL config (/etc/mysql/my.cnf in Ubuntu) file worked. Thanks for your help, maybe I'll be able to get around to writing some PHP at last!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.