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

[MacPorts]

#69531: Cannot initialise the user on mysql 8
---------------------+--------------------
  Reporter:  mrnair  |      Owner:  (none)
      Type:  defect  |     Status:  new
  Priority:  High    |  Milestone:
 Component:  ports   |    Version:
Resolution:          |   Keywords:  mysql8
      Port:  mysql8  |
---------------------+--------------------
Description changed by mrnair:

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
>
> Where can

New 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

--

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