https://bugzilla.novell.com/show_bug.cgi?id=478904 User jo@feuersee.de added comment https://bugzilla.novell.com/show_bug.cgi?id=478904#c4 --- Comment #4 from Jo Schulze <jo@feuersee.de> 2009-03-04 11:35:40 MST --- I could somehow reproduce problems with "hostname" and no hostname at all, but not with "localhost", and not the "duplicate entry" thing. 0) backup any data if not on a test system 1) stop mysql 2) rm /etc/HOSTNAME (or mv to HOSTNAME_BACK) 3) rm everything from /var/lib/mysql/ except the empty dirs .tmp and .protected 4) reboot (just to make sure that the former hostname isn't cached somewhere) Now the system should come up with no hostname (displayed as "(none)" on the login prompt. Try directly or set the hostname with (none):~ # hostname hostname In a new shell the hostname is properly displayed: hostname:~ # rcmysql start [...] Creating MySQL privilege database... hostname: Unknown host WARNING: The host '' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Installing MySQL system tables... ERROR: 1049 Unknown database 'mysql' 090304 18:34:35 [ERROR] Aborting 090304 18:34:35 [Note] /usr/sbin/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! failed hostname:~ # hostname -f hostname: Unknown host hostname:~ # hostname hostname --eof -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.