Projects
New Ticket     Wiki     Browse Source     Timeline     Roadmap     Bug Reports     Search

Ticket #15678 (assigned defect)

Opened 3 months ago

Last modified 3 months ago

mysql_install_db5 failed

Reported by: s.willkommer@… Owned by: ryandesign@…
Priority: Normal Milestone: Port Bugs
Component: ports Version: 1.6.0
Keywords: mysql_install_db5 failed mysql Cc: jwa@…
Port:

Description

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

Change History

Changed 3 months ago by ryandesign@…

  • cc jwa@… added
  • owner changed from macports-tickets@… to ryandesign@…
  • status changed from new to assigned
  • milestone set to Port Bugs
Note: See TracTickets for help on using tickets.