https://bugzilla.novell.com/show_bug.cgi?id=478904 Summary: MySQL fails to initialize DB when silly hostname chosen (first execution of /etc/init.d/mysql) Classification: openSUSE Product: openSUSE 11.1 Version: Final Platform: All OS/Version: openSUSE 11.1 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: jo@feuersee.de QAContact: qa@suse.de Found By: --- User-Agent: Mozilla/5.0 (compatible; Konqueror/3.5; Linux) KHTML/3.5.10 (like Gecko) SUSE A lot of different openSUSE (and other Linux dists or UN*X like systems) related forums have threads like "Can't connect to MySQL" "What's the default password to MySQl" "Can't install MySQL" etc. When trying to reproduce everything went fluid and MySQL is up and running, so WTF are these guys doing wrong? As they state nothing. But: a lot of MySQL depends on a unique well chosen hostname. "If the hostname of the machine is accidentally set to ‘hostname’ or ‘localhost’, it results in a duplicate entry." Yes, it's really stupid to call a machine 'hostname' or even 'localhost' but ppl do that. In this case MySQL will fail to init it's DB and won't allow any access (due to missing DB permissions). Reproducible: Always Steps to Reproduce: 1. 2. 3. Thread in german forum: <http://www.linux-club.de/viewtopic.php?f=36&t=99169> The script /etc/init.d/mysql should check if the hostname is properly set (!= localhost or hostname), fail with a clear message if so (eg. "Unable to continue due to silly hostnane. Please set a proper hostname") -- 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.