Opened 16 years ago

Last modified 10 years ago

#15678 assigned defect

mysql_install_db5 failed

Reported by: s.willkommer@… Owned by: ryandesign (Ryan Carsten Schmidt)
Priority: Normal Milestone:
Component: ports Version: 1.6.0
Keywords: Cc: pixilla (Bradley Giesbrecht), jyrkiwahlstedt
Port: mysql5

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 (4)

comment:1 Changed 16 years ago by ryandesign (Ryan Carsten Schmidt)

Cc: jwa@… added
Milestone: Port Bugs
Owner: changed from macports-tickets@… to ryandesign@…
Status: newassigned

comment:2 Changed 16 years ago by (none)

Milestone: Port Bugs

Milestone Port Bugs deleted

comment:3 Changed 14 years ago by jmroot (Joshua Root)

Keywords: mysql_install_db5 failed mysql removed
Port: mysql5 added

comment:4 Changed 10 years ago by jmroot (Joshua Root)

Cc: pixilla@… added
Note: See TracTickets for help on using tickets.