Problems With Mysql57

Michael Newman mgnewman at
Thu Jul 25 01:45:23 UTC 2019

This was previously reported in March 2019, but nothing since then: <>

Here are the errors:

  mysql57-server has the following notes:
    If this is a new install you might want to run:

    $ sudo /opt/local/lib/mysql57/bin/mysqld --initialize --user=_mysql
    $ /opt/local/lib/mysql57/bin/mysql_secure_installation

MrMuscle:~ mnewman$ sudo /opt/local/lib/mysql57/bin/mysqld --initialize --user=_mysql
2019-07-25T00:47:20.692646Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-25T00:47:20.693843Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2019-07-25T00:47:20.693849Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2019-07-25T00:47:20.703194Z 0 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql57/ is case insensitive
2019-07-25T00:47:21.013714Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-07-25T00:47:21.045721Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-07-25T00:47:21.104765Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c29dee88-ae75-11e9-820c-2e3fb0b57b48.
2019-07-25T00:47:21.124478Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-07-25T00:47:21.126793Z 1 [Note] A temporary password is generated for root at localhost: yCsGrKUda7&-

MrMuscle:~ mnewman$ /opt/local/lib/mysql57/bin/mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:
Error: Can't connect to local MySQL server through socket '/opt/local/var/run/mysql57/mysqld.sock' (2)

MrMuscle:~ mnewman$  sudo port select mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/": target "/opt/local/share/man/mysql57/man1/" doesn't exist

I have no idea what to do next.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the macports-users mailing list