"unable to resolve host" that matter

The "unable to resolve host" is matter when I have problem installing mysql.

Whenever sudo in my hardy , I got "unable to resolve host" . No harm and my terminal works as usual, so just ignore it.

helmi@hix2:~> sudo -s
sudo: unable to resolve host hix2

Then, today wanna use mysql for my pet project.

helmi@hix2:~> sudo dpkg --configure mysql-server-5.0
sudo: unable to resolve host hix2
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.2) ...
* Stopping MySQL database server mysqld
...done.
Reloading AppArmor profiles Warning: found /etc/apparmor.d/force-complain/usr.sbin.named, forcing complain mode
: done.
* Starting MySQL database server mysqld
...fail!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0

Nothing in /var/log/mysql.err or /var/log/mysql.log , but something in /var/log/syslog

Aug 30 05:07:00 hix2 mysqld[2817]: 080830 5:07:00 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host'

Then "unable to resolve host" become matter now. Solution: add following line to /etc/hosts, then reconfigure mysql

127.0.1.1 hix2

Refs:

• http://ubuntuforums.org/showthread.php?t=502982
• http://ubuntuforums.org/showthread.php?t=723361
• https://bugs.launchpad.net/ubuntu/+source/linux-meta/+bug/195308