15,041
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Resource and Environmental Errors
| Line 528: | Line 528: | ||
Solution: [https://stackoverflow.com/questions/17947255/error-in-dropping-a-database-in-mysql-cant-rmdir-oro-errno-41/19888293 phpmyadmin - Error in dropping a database in MySQL (can't rmdir '.\oro', errno: 41) - Stack Overflow] | Solution: [https://stackoverflow.com/questions/17947255/error-in-dropping-a-database-in-mysql-cant-rmdir-oro-errno-41/19888293 phpmyadmin - Error in dropping a database in MySQL (can't rmdir '.\oro', errno: 41) - Stack Overflow] | ||
=== 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. | |||
== Miscellaneous Tool-Specific Errors == | == Miscellaneous Tool-Specific Errors == | ||