[Bug 429618] New: MySQL: Cannot create system tables with localhost as hostname
https://bugzilla.novell.com/show_bug.cgi?id=429618 Summary: MySQL: Cannot create system tables with localhost as hostname Product: openSUSE 11.0 Version: Final Platform: All OS/Version: Linux Status: NEW Severity: Normal Priority: P5 - None Component: Installation AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: mopp@gmx.net QAContact: jsrain@novell.com Found By: System Test Hi, I' m using openSUSE 11 i686 with mysql-5.0.51a-27.1. Found a bug during the first mysql start, if the hostname is localhost. The mysql.user table cannot be initialize correctly, as the mysql tries to add the hostname localhost 2 times. localhost:/var/lib/mysql # hostname -f localhost localhost:/var/lib/mysql # /etc/init.d/mysql start Creating MySQL privilege database... Installing MySQL system tables... ERROR: 1062 Duplicate entry 'localhost-' for key 1 080924 18:48:19 [ERROR] Aborting 080924 18:48:19 [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 Please fix the problem. -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=429618
Robert Vojcik
https://bugzilla.novell.com/show_bug.cgi?id=429618
Michal Marek
https://bugzilla.novell.com/show_bug.cgi?id=429618
User mmarek@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=429618#c1
--- Comment #1 from Michal Marek
https://bugzilla.novell.com/show_bug.cgi?id=429618
User mmarek@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=429618#c2
--- Comment #2 from Michal Marek
https://bugzilla.novell.com/show_bug.cgi?id=429618
User mmarek@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=429618#c3
Michal Marek
participants (1)
-
bugzilla_noreply@novell.com