Opened 8 months ago
Last modified 5 months ago
#69531 assigned defect
Cannot initialise the user on mysql 8
| Reported by: | mrnair (Abhijith Nair) | Owned by: | herbygillot (Herby Gillot) |
|---|---|---|---|
| Priority: | Normal | Milestone: | |
| Component: | ports | Version: | |
| Keywords: | Cc: | cooljeanius (Eric Gallager) | |
| Port: | mysql8 |
Description (last modified by ryandesign (Ryan Carsten Schmidt))
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
Change History (4)
comment:1 Changed 8 months ago by mrnair (Abhijith Nair)
| Description: | modified (diff) |
|---|
comment:2 Changed 8 months ago by jmroot (Joshua Root)
| Keywords: | mysql8 removed |
|---|---|
| Owner: | set to herbygillot |
| Priority: | High → Normal |
| Status: | new → assigned |
comment:3 Changed 8 months ago by ryandesign (Ryan Carsten Schmidt)
| Description: | modified (diff) |
|---|
comment:4 Changed 5 months ago by cooljeanius (Eric Gallager)
| Cc: | cooljeanius added |
|---|
Note: See
TracTickets for help on using
tickets.