Opened 6 months ago
Last modified 4 months ago
#69531 assigned defect
Cannot initialise the user on mysql 8 — at Initial Version
| Reported by: | mrnair (Abhijith Nair) | Owned by: | |
|---|---|---|---|
| Priority: | Normal | Milestone: | |
| Component: | ports | Version: | |
| Keywords: | Cc: | ||
| Port: | mysql8 |
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