Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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, using a mySQL GUI it shows him as being root@''. 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 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

Hi this should answer your question.

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


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.