#15678: mysql_install_db5 failed --------------------------------------------+------------------------------- Reporter: s.willkommer@techdivision.com | Owner: macports-tickets@lists.macosforge.org Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.6.0 Keywords: mysql_install_db5 failed mysql | --------------------------------------------+------------------------------- i'm trying this for about a couple of days without success. everytime the same error. but from the front. i've installed php5 apache2 and mysql5 with the this tutorial [http://samuraicoder.net/installing_php_and_mysql_leopard_macports_prealpha]. Everything is fine but when i try to install the system db tables with following command {{{ sudo -u mysql mysql_install_db5 }}} i got this error {{{ Installing MySQL system tables... ERROR: 1062 Duplicate entry 'localhost-' for key 1 080619 17:35:19 [ERROR] Aborting 080619 17:35:19 [Note] /opt/local/libexec/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /opt/local/var/db/mysql5 for more information. You can try to start the mysqld daemon with: /opt/local/libexec/mysqld --skip-grant & and use the command line tool /opt/local/lib/mysql5/bin/mysql to connect to the mysql database and look at the grant tables: shell> /opt/local/lib/mysql5/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /opt/local/var/db/mysql5 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 /opt/local/lib/mysql5/bin/mysqlbug script! }}} If I try to connect I got an access denied error. I've tried to delete the databases under /opt/local/var/db/mysql5/ and installed again without success. I have the macports 1.6.0 an a mac osx completely new installed with all updates (10.5.3) . Last week we installed it on three other macs in our company and it works perfectly. Im totally helpless about that. Thanks for your help -- Ticket URL: <http://trac.macports.org/ticket/15678> MacPorts <http://www.macports.org/> Ports system for Mac OS