[Bug 209512] mysql57-server-5.7.12: Server not usable after installation

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=209512

            Bug ID: 209512
           Summary: mysql57-server-5.7.12: Server not usable after
                    installation
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs at FreeBSD.org
          Reporter: rkean at bitmessage.ch

I hope this is the right place to report this bug:

When I run "pkg install mysql57-server-5.7.12" on a quite fresh install of
10.3-RELEASE on amd64, the installation completes without an error, but the
mysql server does not start.

Even after adding 'mysql_enable="YES"' to /etc/rc.conf, running "service
mysql-server start" results in:
"/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql"
The server will remain down.

Running "/usr/local/libexec/mysqld" manually, part of the output reads:
"mysqld: Table 'mysql.plugin' doesn't exist
2016-05-14T22:36:31.093854Z 0 [ERROR] Can't open the mysql.plugin table. Please
run mysql_upgrade to create it.
mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or
directory)
2016-05-14T22:36:31.115349Z 0 [Warning] World-writable config file './auto.cnf'
has been removed.
[...]
2016-05-14T22:36:32.480871Z 0 [Warning] Failed to open optimizer cost constant
tables

2016-05-14T22:36:32.481295Z 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.user' doesn't exist
2016-05-14T22:36:32.481436Z 0 [ERROR] Aborting"

The process then terminates in what appears to be a graceful manner.

If I can help sort this out, please let me know how, but please keep in mind
that I'm quite new to FreeBSD and thus may need certain things to be spelled
out to me.

Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.