[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:
 Keywords:  mysql8  |       Port:  mysql8
--------------------+--------------------
 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

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