[MacPorts] #69531: Cannot initialise the user on mysql 8
MacPorts
noreply at macports.org
Mon Mar 18 08:44:09 UTC 2024
#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
More information about the macports-tickets
mailing list