Troubleshooting of MySQL errors: Difference between revisions

Jump to navigation Jump to search
Line 425: Line 425:
* Find the Terminal app or iTerm2 or whatever terminal you are using and check the box to allow full disk access.
* Find the Terminal app or iTerm2 or whatever terminal you are using and check the box to allow full disk access.
* Restart your terminal.
* Restart your terminal.
== Database and Table Operation Errors ==
== Access and Authentication Errors ==
== SQL and Query Errors ==
== Connection and Network Errors ==


== Resource and Environmental Errors ==
== Resource and Environmental Errors ==
Line 472: Line 480:


* Increase the value of {{kbd | key = <nowiki>max_allowed_packet</nowiki>}}<ref>[https://stackoverflow.com/questions/5688403/how-to-check-and-set-max-allowed-packet-mysql-variable php - how to check and set max_allowed_packet mysql variable - Stack Overflow]</ref> if the MySQL user has the {{kbd | key = <nowiki>SUPER</nowiki>}} privilege<ref>[https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html MySQL :: MySQL 8.0 Reference Manual :: 6.2.2 Privileges Provided by MySQL]</ref>.
* Increase the value of {{kbd | key = <nowiki>max_allowed_packet</nowiki>}}<ref>[https://stackoverflow.com/questions/5688403/how-to-check-and-set-max-allowed-packet-mysql-variable php - how to check and set max_allowed_packet mysql variable - Stack Overflow]</ref> if the MySQL user has the {{kbd | key = <nowiki>SUPER</nowiki>}} privilege<ref>[https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html MySQL :: MySQL 8.0 Reference Manual :: 6.2.2 Privileges Provided by MySQL]</ref>.
== Miscellaneous Tool-Specific Errors ==


== References ==
== References ==

Navigation menu