Opened 10 years ago

Last modified 6 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 10 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 10 years ago by carbonturtle (Michael Hosford) (previous) (diff)

comment:3 Changed 10 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 10 years ago by pixilla (Bradley Giesbrecht) (previous) (diff)

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

Owner: pixilla deleted
Status: newassigned

See #57827

Note: See TracTickets for help on using tickets.