15,041
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Resolve insufficient hard disk space where mysql data located
mNo edit summary |
|||
| Line 566: | Line 566: | ||
== Resolve insufficient hard disk space where mysql data located == | == Resolve insufficient hard disk space where mysql data located == | ||
[http://errerrors.blogspot.com/2016/07/mysql.html Err: 解決 MySQL 資料庫所在硬碟空間不足的狀況] | [http://errerrors.blogspot.com/2016/07/mysql.html Err: 解決 MySQL 資料庫所在硬碟空間不足的狀況] | ||
== How to resolve "zsh: operation not permitted: xxx.sql" == | |||
Error condition | |||
<pre> | |||
/applications/MAMP/library/bin/mysql -u [USERNAME] -p [DATABASE_NAME] < [PATH_TO_SQL_FILE] | |||
zsh: operation not permitted: PATH_TO_SQL_FILE.sql | |||
</pre> | |||
Solution: Check Security & Privacy Settings: macOS may block certain actions from the terminal due to security settings. You can try allowing full disk access to the terminal: | |||
* Open System Preferences. | |||
* Go to Security & Privacy. | |||
* Select the Privacy tab. | |||
* Scroll down to Full Disk Access. | |||
* Click the lock icon to make changes (you might need your administrator password). | |||
* Find the Terminal app or iTerm2 or whatever terminal you are using and check the box to allow full disk access. | |||
* Restart your terminal. | |||
== References == | == References == | ||