[MacPorts] #15678: mysql_install_db5 failed

[MacPorts]

#15678: mysql_install_db5 failed
--------------------------------------------+-------------------------------
 Reporter:  s.willkommer at techdivision.com   |       Owner:  macports-tickets at 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