This was previously reported in March 2019, but nothing since then:
https://lists.macports.org/pipermail/macports-users/2019-March/046514.html
<https://lists.macports.org/pipermail/macports-users/2019-March/046514.html>
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@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/mysql-stress-test.pl.1.gz": target
"/opt/local/share/man/mysql57/man1/mysql-stress-test.pl.1.gz" doesn't exist
I have no idea what to do next.
