15,041
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→References
m (→References) |
|||
| Line 420: | Line 420: | ||
* 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. | ||
== Other issues == | |||
=== could not access the mysql log === | |||
Version: XAMPP 5.6.15-1 on {{Mac}} | |||
Cause: | |||
* the error log only be accessed by the user named {{kbd | key=mysql}}<ref>Open the MySQL configuration file located: /Applications/XAMPP/xamppfiles/etc/my.cnf | |||
<pre> | |||
# The MySQL server | |||
[mysqld] | |||
user = mysql | |||
</pre></ref> | |||
Solution <ref>[http://computerplumber.com/2009/01/using-the-chmod-command-effectively/ Using the CHMOD command effectively @ Computer Plumber]</ref>: | |||
<pre> | |||
find the path to the mysql log | |||
$ ls /Applications/XAMPP/xamppfiles/var/mysql/*.local.err | |||
find the file name of mysql log ex: XXXMacBook-Pro.local.err | |||
set the permission of log | |||
$ sudo chmod 774 /Applications/XAMPP/xamppfiles/var/mysql/XXXMacBook-Pro.local.err | |||
</pre> | |||
== References == | == References == | ||