[MacPorts] #69531: Cannot initialise the user on mysql 8

[MacPorts]

#69531: Cannot initialise the user on mysql 8
---------------------+-------------------------
  Reporter:  mrnair  |      Owner:  herbygillot
      Type:  defect  |     Status:  assigned
  Priority:  Normal  |  Milestone:
 Component:  ports   |    Version:
Resolution:          |   Keywords:
      Port:  mysql8  |
---------------------+-------------------------
Description changed by ryandesign:

Old description:

> I am following the documentation in macports site
> (https://trac.macports.org/wiki/howto/MySQL) to install mysql8 in my Mac
> (OS- catalina).
>
> But, I am getting the below error
>
> 2024-03-18T05:58:16.603714Z 0 [ERROR] [MY-000077] [Server]
> /opt/local/lib/mysql8/bin/mysqld: Error while setting value
> 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
> to 'sql_mode'.
> 2024-03-18T05:58:16.603738Z 0 [ERROR] [MY-013236] [Server] The designated
> data directory var/db/mysql8 is unusable. You can remove all files that
> the server added to it.
> 2024-03-18T05:58:16.603809Z 0 [ERROR] [MY-010119] [Server] Aborting
>
> Is it not supported on old versions of mac
> 2024-03-18T05:58:16.603984Z 0 [Note] [MY-010120] [Server] Binlog end

New description:

 I am following the documentation in macports site (wiki:howto/MySQL) to
 install mysql8 in my Mac (OS- catalina).

 But, I am getting the below error

 {{{
 2024-03-18T05:58:16.603714Z 0 [ERROR] [MY-000077] [Server]
 /opt/local/lib/mysql8/bin/mysqld: Error while setting value
 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
 to 'sql_mode'.
 2024-03-18T05:58:16.603738Z 0 [ERROR] [MY-013236] [Server] The designated
 data directory var/db/mysql8 is unusable. You can remove all files that
 the server added to it.
 2024-03-18T05:58:16.603809Z 0 [ERROR] [MY-010119] [Server] Aborting
 }}}

 Is it not supported on old versions of mac
 {{{
 2024-03-18T05:58:16.603984Z 0 [Note] [MY-010120] [Server] Binlog end
 }}}

--

-- 
Ticket URL: <https://trac.macports.org/ticket/69531#comment:3>
MacPorts <https://www.macports.org/>
Ports system for macOS