MySQL 9.0 (MacOS) failed to initialize database after installation
I had 8.3 installed before on the Mac. It was uninstalled before I install the 9.0 version.
I also deleted _mysql user from 'Directory Utility'. I don't know if this would cause any problem subsequently. I thought a new installation will re-create _mysql user in the Directory Utility, but it doesn't.
I install 9.0 using .dmg. The installation is completed successfully. The step of initializing database fails. I did this step using the utility in MacOS system preference as well as command line mysqld --initialize.
The command line gave me the clearer error:
[ERROR] [MY-013276] [Server] Failed to set datadir to '/usr/local/mysql-9.0.0-macos14-x86_64/data/' (OS errno: 13 - Permission denied)
The 'data' directory as in /usr/local/mysql/data has permission
drwxr-x--- 31 _mysql _mysql 992 Jul 14 06:13 data
What should I do? Should I change the permission for 'data' to wrxwrxwrx?
I am really a novice for database server. Please help.
Subject
Written By
Posted
MySQL 9.0 (MacOS) failed to initialize database after installation
July 13, 2024 04:27PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.