Troubleshooting of MySQL errors: Difference between revisions

Troubleshooting of MySQL errors (edit)

751 bytes removed , 12 May 2024

m

15,041

edits

@@ Line 346: / Line 346: @@
 == Resolve insufficient hard disk space where mysql data located ==
 [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.
 == Database and Table Operation Errors ==