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: | new → assigned |
comment:2 Changed 16 years ago by (none)
Milestone: | Port Bugs |
---|
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 |
---|
Milestone Port Bugs deleted