XAMPP on mac OS: MySQL won't start after manipulating file permissions, how to extract databases?

Question

MySQL

The entire XAMPP folder and all nested files and folders (/Applications/XAMPP) have their permissions changed to "read and write for everyone". (yes, this is a stupid and a priori fatal action, but this is a separate issue, the human factor worked - processing, fatigue and “driven” from above affected, they wanted to close projects as soon as possible).
The launch of the Apache somehow managed to be restored, but MySQL still does not start.
We tried to "feed" the XAMPP/xamppfiles/var/mysql folder and its contents (in various variations) to a freshly installed XAMPP on another machine - to no avail. By the way, it is in this folder with the rights that something is wrong. On fresh XAMPP, access rights are set there only for the MySQL user (how to set them and at the same time remove MAC admin rights - we don’t know, and will it help?).
Here is what the error_log file produces when trying to start the server

Wed Nov 20 20:34:51.412471 2019] [core:notice] [pid 32127] AH00094: Command line: '/Applications/XAMPP/xamppfiles/bin/httpd -E /Applications/XAMPP/xamppfiles/logs/error_log -D SSL -D PHP'
[Thu Nov 21 10:13:47.219522 2019] [mpm_prefork:notice] [pid 32127] AH00169: caught SIGTERM, shutting down
[Thu Nov 21 10:18:49.585016 2019] [ssl:warn] [pid 688] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Nov 21 10:18:49.625849 2019] [ssl:warn] [pid 688] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Nov 21 10:18:49.994456 2019] [ssl:warn] [pid 693] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Nov 21 10:18:50.028700 2019] [ssl:warn] [pid 693] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Nov 21 10:18:50.029024 2019] [lbmethod_heartbeat:notice] [pid 693] AH02282: No slotmem from mod_heartmonitor
[Thu Nov 21 10:18:51.191121 2019] [mpm_prefork:notice] [pid 693] AH00163: Apache/2.4.39 (Unix) OpenSSL/1.0.2s PHP/7.1.30 mod_perl/2.0.8-dev Perl/v5.16.3 configured -- resuming normal operations
[Thu Nov 21 10:18:51.191488 2019] [core:notice] [pid 693] AH00094: Command line: '/Applications/XAMPP/xamppfiles/bin/httpd -E /Applications/XAMPP/xamppfiles/logs/error_log -D SSL -D PHP'

In the mysql folder there are folders with the names of the databases and the files table_name.frm and table_name.ibd, there is also an ibdata1 file. But, as I understood after googling in this direction, restoring from these files is a very time-consuming process and you need to restore each table in stages (as many as 5 databases are subject to restoration, so this is not an option).

Answer 1

Try to start MySQL and look in the logs - /var/log/system.log and MySQL (I don't know exactly where they are in XAMPP, in normal systems under /var/log/)
I don't think MySQL is not understood because of the rights, but you can see the "correct" permissions on XAMPP/xamppfiles/var/mysql on another machine and fix it with chmod.