Opened 10 years ago

Last modified 5 years ago

#44978 assigned defect

mysql56: Cannot create database at end of installation.

Reported by: murrayeisenberg@… Owned by:
Priority: Normal Milestone:
Component: ports Version: 2.3.1
Keywords: Cc:
Port: mysql56

Description (last modified by ryandesign (Ryan Carsten Schmidt))

I installed mysql56-server @5.6.19_1 under OS X 10.9.4.

Following instructions at wiki:howto/MAMP, I executed:

   sudo port select mysql mysql56
   sudo -u _mysql /opt/local/lib/mysql56/bin/mysql_install_db   [NOT "_db5"]

Result:

  WARNING: Could not write to config file /opt/local/etc/mysql56/my-new.cnf: Permission denied
  FATAL ERROR: Could not find /fill_help_tables.sql

I tried doing "chown _mysql:_mysql /opt/local/etc/mysql56/my-new.cnf", which did cure the first error.

However, the 2nd error persist.

In fact, after updating the located, an mdfind reveals:

   mdfind -name fill_help_tables.sql
   /opt/local/share/mysql56/fill_help_tables.sql

So how should this be fixed?

Change History (4)

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

Cc: pixella@… removed
Description: modified (diff)
Keywords: installation removed
Owner: changed from macports-tickets@… to pixilla@…
Port: mysql56 added; mysql56-server @5.6.19_1 removed
Summary: mysql56-server: Cannot create database at end of installation.mysql56: Cannot create database at end of installation.

comment:2 Changed 9 years ago by carbonturtle (Michael Hosford)

I'm having the same problem the OP describes, under OS X 10.6.8.

EDIT: I uninstalled mysql56-server and re-installed it. This time, I didn't get the first warning about being unable to write to the config file, but I still get the fatal error about not being able to find "fill_help_tables.sql". I tried specifying --basedir "/opt/local" after examining the mysql_install_db script to see how it builds the paths to the files. I also verified that "fill_help_tables.sql" exists in /opt/local/share/mysql56/ and should be readable by anybody.

Any help, hints, pointers welcome.

Thanks-- Michael

ANOTHER EDIT: Okay, operator error, sorry! I discovered a long-forgotten ~/.my.cnf that was confusing matters. I deleted it, and mysql_install_db was able to run successfully. I'll leave this comment here in case anyone else can be helped by it (my public shame notwithstanding, haha).

Last edited 9 years ago by carbonturtle (Michael Hosford) (previous) (diff)

comment:3 Changed 9 years ago by pixilla (Bradley Giesbrecht)

michael: Thank you for the feedback.
murrayeisenberg: Check if mysql is picking up a my.cnf from somewhere other than $prefix/etc/mysql56:

$ ls $(/opt/local/lib/mysql56/bin/mysqld --help --verbose 2>&1 | grep -A 1 "Default options" | sed '1d')
Last edited 9 years ago by pixilla (Bradley Giesbrecht) (previous) (diff)

comment:4 Changed 5 years ago by mf2k (Frank Schima)

Owner: pixilla deleted
Status: newassigned

See #57827

Note: See TracTickets for help on using tickets.